Forum Discussion
Solved
Composite Models using Power BI datasets, Calculated tables and Scheduled Refresh
I have a composite model that includes a single Power BI dataset. The model also includes calculated tables that refer to tables in the Power BI dataset. Refresh works in Power BI desktop. In the Po...
theres a actual limitation on this aspect where calculated columns/tables using a compiste model between power BI dataset live in direct query mode and any other source will give you that exact error, it isnt avaible right now, again this a limitation only for power bi dataset in direct query mode.
had the same scenario a few months ago and with the microsoft support team got to this limitation for this scenario,
if this helped give some kudos and mark as solution for others to find,
Anyone knows the solution? It's year 2025