Forum Discussion
Composite Models using Power BI datasets, Calculated tables and Scheduled Refresh
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,
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,
*Workaround for those with smaller and simpler datasets*
Re: Refreshes for Datasets containing Calculated T... - Microsoft Fabric Community
(2023/07/05)
***
Hey Stefano - Thanks so much for submitting the idea to the developers (upvoted!). Just wanna ask if you have any advice on the next best workaround on this? I also thought that it's quite neat that we can build reports from datasets so it's such a letdown that the auto-refresh is not available in the service. 😕