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,
Thanks Stefano...yes in fact that was our discovery a little too late in the game. We developed a perfectly working model on the desktop only to realize it cannot be refreshed upon publication to the service. I hope they can fix this limitation soon but I'm a bit skeptical as the direct query to a pbi dataset within a composite model has already been in preview for 11 months 😕
you can vote here to see if they consider this idea to modify this so it can work:
here the idea link: https://community.powerbi.com/t5/Custom-Visuals-Ideas/Allow-Power-BI-Dataset-Direct-Query-composite-Model-on-power-bi/idi-p/2125753#M749