cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dcao
Frequent Visitor

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 the data sets.

If I give them access to the workspace as members, then the visuals show up fine, but that's not what I want because now I cannot enable RLS with them being members of the workspace. 

dcao_0-1610133003526.png

 

 

6 REPLIES 6
kevhav
Responsive Resident
Responsive Resident

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
Resident Rockstar
Resident Rockstar

Hi @dcao 

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

 

aj1973_1-1610756734350.png

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?

 

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!
aj1973
Resident Rockstar
Resident Rockstar

Hi @dcao 

Yes you can deploy RLS to the datasets. The Row Level Security needs to be set in Power Bi desktop though.

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!
dcao
Frequent Visitor

Hey Amine,

 

Yes, but what I meant was that I'm connected to 2 power bi datasets.

However, one of that datasets is giving blank visuals for users with view permission to the app.

If I give them access to the workspace as members, then the visuals work. I don't know why, but I don't want that because now RLS will not work because they're member of the workspace

dcao_0-1610322299905.png

 

dcao_1-1610322382090.png

 

 

 

Hi, @dcao 

Maybe you just forgot to manage security on your model .

Datasets->Security->Row-Level Security-> select  one of the 'role'  you create on PowerBI Desktop -> enter the Members' email addresses to assign the  role

 

For more details , please refer to this document.

manage-security-on-your-model 

 

If you are using Dynamic RLS ,please recheck your \userprincipalname formats.

RLS-working-with-desktop-but-not-on-service-after-publishing 

using-the-username-or-userprincipalname-dax-function 

 

 

Best Regards,
Community Support Team _ Eason

I don't think you guys are understanding my issue. 

The problem is that I have reports connected to 2 power bi data sets ( Direct Query for Power BI Data Sets). My users have view access to the App. The visuals from 1 of the power bi datasets are not showing up in the service, but if I give them access to the workspace as memebers, then the visuals show up fine.

However, I don't want them to be members of the workspace. I just want them to have view access to the app. 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors