Error after export calculated table to tabular server

tom_om — Tue, 21 Dec 2021 09:39:33 GMT

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.

Re: Error after export calculated table to tabular server

tom_om — Tue, 21 Dec 2021 12:39:17 GMT

Resolved: The QURTER function is not allowed even though it is not an error in Visual Studio.

topic Error after export calculated table to tabular server in Report Server

Error after export calculated table to tabular server

Re: Error after export calculated table to tabular server