cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
davidbrunelle
Regular Visitor

Is it possible to remove authentication from a PowerBI App ?

We are making a report that takes data from our dataverse and would like to display it to our customers. We have quite a few customer (about 1000), so sharing for each and everyone of them is a chore and since all the infos comes from this one source, we though we could make a power bi app (using template app) and filter using a parameter we will provide them. When we test it in our own tenant, it all works fine, though we need to authenticate the application using oauth2, which is ok for us. 

Once we try with one customer though it stops working because the custome needs to login to our tenant which is not possible as he is not a user and we get an error :

SQL: "RetrievePrivilegeForUser: The user with id b3571f5c-5759-ee11-be6f-0022483d05a3 has not been assigned any roles. They need a role with the prvReadContact privilege."

Which clearly state the the user (I check the guid, it's an external user in this case because she has access to our tenant as guest) does not have access to dataverse, which makes sense.

 

So my question is: Can we force the PowerBI App to ignore this and just use the credential that are provided when we design the report, like it is in our own tenant and is yes how ?

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@davidbrunelle Seems like a perfect use case for Power BI Embedded (A SKU's). Other option would be to give them read access to the Dataverse entities they need. Either way though, I don't see how you get around the need to essentially share something with all of those users/companies.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

This sounds a little extreme doesn't it ? I though the whole idea of a PowerBI Template App was to prevent this. 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

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

Top Solution Authors