Solved: RLS Query

Parashivamurthy · ‎10-01-2018

Hi,

I have a solution created under power bi desktop with multiple roles. The same has been deployed to Power BI services and we have created a content pack (this has been created before app workspace release).

There are 4 reports and dashboards created under this solution and if i publish this content, users are able to see only 3 reports content, the 4th report is showing blank.

Can you please help me with the issue.

Thanks in advance!report screen

Regards,

Murthy | Data Analyst

Parashivamurthy · ‎10-03-2018

Hi Cherry,

The issue has been resoved.

The issue is with the permission. The solution which we have created was under some user credential which he doesn't have sufficient permisison. Since he deployed from his login, we were not able to see the content.

I have deployed the solution with admin credentials, the issue got resolved.

Error: The dashbaord contains the tiles which you does not own.

Regards,

Murthy | Data Analyst

View solution in original post

v-piga-msft · ‎10-01-2018

Hi @Parashivamurthy,

Does the report show blank using the same dataset with the other reports? What‘s the data source of the report?

Does RLS for this report work successfully on Power BI Desktop?

You could test role in Power BI service to check if it works with RLS?

In addition, you could have a reference of this similar thread.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Parashivamurthy · ‎10-02-2018

Hi Cherry,

Does the report show blank using the same dataset with the other reports? What‘s the data source of the report?

The content pack has been published with multiple different datasets which points to the same data source. I have other content packs published with RLS. I am not facing this issue for them.

Does RLS for this report work successfully on Power BI Desktop?

Yes it works perfectly fine in Power BI Desktop.

You could test role in Power BI service to check if it works with RLS?

I have tested the same. the role is working fine in Power BI services, test as a role.

In addition, you could have a reference of this similar thread.

I don't think its because of relationship. I have checked that as well.

Regards,

Murthy | Data Analyst

Parashivamurthy · ‎10-03-2018

Hi Cherry,

The issue has been resoved.

The issue is with the permission. The solution which we have created was under some user credential which he doesn't have sufficient permisison. Since he deployed from his login, we were not able to see the content.

I have deployed the solution with admin credentials, the issue got resolved.

Error: The dashbaord contains the tiles which you does not own.

Regards,

Murthy | Data Analyst