calculated table
1 Topic
Error after export calculated table to tabular server
1. I have deploy model with calculated table =ADDCOLUMNS( CALENDAR ( DATE (2021,1,1), DATE (2021,12,31) ), "Miesiąc Rok",FORMAT ( [Date], "mmm yyyy" ), "Rok Miesiąc", FORMAT ( [Date],"yyyy mmm" ), "Rok Miesiąc Numer", FORMAT ( [Date], "yyyy-mm" ), "Miesiąc Rok SORT", YEAR([Date]) * 100 + MONTH([Date]), "Kwartał","Q" & QUARTER ( [Date] ), "Kwartał Numer", QUARTER ( [Date] ), "Kwartał Rok","Q" & QUARTER ( [Date] ) & FORMAT ( [Date], " yyyy" ), "Rok Kwartał",FORMAT ( [Date], "yyyy " ) & " Q" & QUARTER([Date]), "Kwartał Rok SORT",YEAR([Date]) * 100 + QUARTER([Date]), "CzyAktualnyMiesiac",IF(YEAR([Date]) = YEAR(NOW()) && MONTH([Date]) = MONTH(NOW()),1,0), "Rok",YEAR([Date]), "Miesiąc",MONTH([Date]) ) 2. Second source is db2 database After deploy i have error when i add calculated table to Power BI "DataSource.Error: AnalysisServices: The query referenced calculated table 'Data' which does not hold any data because there is an error in its expression. Details: DataSourceKind=AnalysisServices DataSourcePath=w6q7-tst2;TabularProject2test" Sources Db2 working ok. Everything working OK in Excel Power Query.Solved650Views0likes1Comment