Forum Discussion
Direct Query error: DirectQuery may not be used with this data source
Hi all,
I have been using dataverse as my data source. In the homepage, i did some filter condition on a table which is a direct query table from dataverse.
The formula works, and i am able to get my expected result. However, after i publish, in my power bi service, i am getting an error. and after i re-open the desktop version,i received error as below:
DirectQuery error: DirectQuery may not be used with this data source - please consider moving to a supported data source or upgrading the sql server data source to the latest available version.
how do i fix this? i thought dataverse would work perfectly with directquery
4 Replies
Hi, kilala
Ensure that you have checked the settings page of the report's dataset in the Power BI service to see if a gateway configuration or credential editing is necessary.
Filter condition on a table in a DQ mode maybe a limitation.
remove the transformation and see if that works.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Hi,
i didnt do any transformation directly to the table.
I just created some measures to achieve below objective:
i have a navigation menu:
1. summary
2. details
3. admin
role admin can be navigate by admin only. Hence, following below article,
https://www.linkedin.com/pulse/enable-disable-button-specific-users-powerbi-keith-fernandes/
i created some measures to detect what is the user role, and then configure the actions when they click on the navigation menu.it works fine when i test in desktop but when i save and re-open, that error occur. i noticed that i have to wait for some time and then choose Optimize -->Refresh visuals then only it would work.
but the same error will happen when i publish it and i dont think my client is willing to wait just to navigate to page.
i hope any one can chip in any idea on this.or maybe other workaround i can try to achieve the objective apart from article shared?
Hey, try to use RLS as an alternative approach.
refer: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
