Forum Discussion

kilala's avatar
kilala
Resolver I
2 years ago

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 ...
Need Help
Show and Tell
rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

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. 

 

https://community.fabric.microsoft.com/t5/Issues/Direct-Query-not-working-with-Dataverse-and-PBI-dataset-in-Power/idi-p/2456741

 

remove the transformation and see if that works. 

 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

kilala's avatar
kilala
Resolver I
2 years ago

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?