Forum Discussion
DirectQuery enabled but not working
Hi Anonymous
There are some considerations and limitations for using directquery for Power BI Dataset.
-
To be able to make a DirectQuery connection to a Power BI dataset, your tenant needs to have "Allow XMLA Endpoints and Analyze in Excel with on-premises datasets" enabled.
-
For premium capacities, the "XMLA endpoint" should be set to either "Read Only" or "Read/Write".
-
If using a classic workspace in combination with this feature, it is not sufficient to set permissions on the dataset itself. For classic workspaces, all users accessing reports that leverage this feature must be members of the workspace. Consider upgrading classic workspaces to new workspaces to avoid this situation.
You can refer to this offical blog to learn more details.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
Anonymous , Ffor power bi Dataflow to work as direct query, you also need to set -Enhance compute engine on - Under dataflow setting
Thank amitchandak
Where can I find this setting? My data is set as datasets in Service, not dataflows, or does that not matter?
Hi Anonymous
There are some considerations and limitations for using directquery for Power BI Dataset.
-
To be able to make a DirectQuery connection to a Power BI dataset, your tenant needs to have "Allow XMLA Endpoints and Analyze in Excel with on-premises datasets" enabled.
-
For premium capacities, the "XMLA endpoint" should be set to either "Read Only" or "Read/Write".
-
If using a classic workspace in combination with this feature, it is not sufficient to set permissions on the dataset itself. For classic workspaces, all users accessing reports that leverage this feature must be members of the workspace. Consider upgrading classic workspaces to new workspaces to avoid this situation.
You can refer to this offical blog to learn more details.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-