Forum Discussion

dcao's avatar
dcao
Frequent Visitor
5 years ago

Direct Query for Power BI Datasets cannot display visuals for one of the datasets for App viewers

I am connected to 2 power bi datasets through Direct Query with the new Dec feature.   I have granted the users access to the app as usual. The problem is that they can only see data from one of t...
Need Help
kevhav's avatar
kevhav
Continued Contributor
5 years ago

We are experiencing this same issue. We are not using RLS at all. We are testing out Using DirectQuery for Power BI datasets and Azure Analysis Services (preview).

 

We have DatasetA and DatasetB, both in WorkspaceX. And WorkspaceX is in Premium Capacity. We created a new "Test.pbix" file with a live, "Power BI datasets" connection to DatasetA; and a live, "Power BI datasets" connection to DatasetB. And we combined tables from the two datasets in a single data model in "Test.pbix"

 

It works in Power BI Desktop. I published "Test.pbix" to WorkspaceX, and I can view the report in the workspace. I added "Test" to the app in WorkspaceX and updated the app. I can go into the app and view the report, and it works. Also, everything works for other users who are members of WorkspaceX and have Pro licenses.

 

However, for our users who are not members of WorkspaceX and don't have Pro licenses...when they open the report in the app, they get an error on any visual that has data from DatasetA ("Can't display the visual"). But if the visual has data only from DatasetB, they can see it just fine.

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi dcao 

    I think the key answer to your issue is the link you provided, There are multiple limitations

     

    Are you applying one of those limitation to Dataset A?

    Another quetion that came to mind, are Dataset A and B connected via the same Gateway?