Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.


Follow on LinkedIn
@ 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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors