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.
