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

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?