Forum Discussion
Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th
Hi Anonymous and all,
I am happy that when ticking "Disabling this item from datasources..." it works
However the explanation given by the microsoft post isn't quite clear for me.
https://powerbi.microsoft.com/en-us/blog/enabling-granular-access-control-for-all-data-connection-types/
Is it only me? this feature is more around controlling which users can "modify" the dataset and better control (from IT dept let's say) the connections. But in this specific thread and this scenario we are not talking about modifying the dataset right? or am I confused? Is this because in the composite model when adding a calc table over a DQ it "modifies" the dataset?
I like to understand things and not only be happy when it works after clicking a button (although I am really happy here 😃)
Also is seems it only works on our side when enabling both Authentication and SSO:
at first I used only SSO but it didn't work. When enabling both it can refresh the model with mix of import/DQ and calc tables over DQ.
Any comments/explanations are welcomed! Sometimes the community is the best way to find answers! 😉
Thanks
If your data source is a semantic model (dataset), you will get this error if you create a calculated table. The solution is to create the calculated table in the original report/dataset (and publish/refresh), or to use an alternative solution (and delete the calculated table).