DataSource.Error Help

[garzajnc24]

DataSource.Error: AnalysisServices: The query referenced calculated table '<ccon>Fact_Ledger</ccon>' which does not hold any data because there is an error in its expression.

Hello all,

I am receiving this error with previously made PBI reports and getting data on both the desktop and service. Any insights on how to investigate and fix the problem? Thanks.

[nandic · Accepted solution]

@garzajnc24 the issue is in DAX for calculated table "Fact_Ledger".
Either there is syntax issue or logic (referencing some columns that are removed or renamed), but this is the issue.
You need to fix dax for this calculated table.

Cheers,
Nemanja Andic