BI data shaping - Enterprise database + One drive for business

[rittsui]

Hi, 

I am now building a report from PowerBI linking source of:
1. enterprise datasource data gateway
2. excel file from one drive of business.

At the end, I successfully build up the file and publish to the sharespace with my team.
However, only me can read the data in the report while the rest of the users showing all errors and can read nothing.

Anything I can do to let all users to read the data?
Thanks a lot.

[v-yuezhe-msft · Accepted solution]

@rittsui,

When configuring RLS in Power BI dataset, you would need to add the users as RLS role members in Power BI Service, otherwise they will not be able to view reports.

Regards,
Lydia

[rittsui]

Thank you for your message.
I just figured out it's because I set some RLS level security and the problem is solved now.
Many thanks.

[v-yuezhe-msft]

@rittsui,

What error message do the users get? How do you share the Power BI report to the users in Power BI Service?

Regards,

Lydia