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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
artfajri
New Member

Data not showing by visitor, but shows for me

Hi everyone, 

 

kindly need help for my BI report. the problem is, if I myself open the power BI app that I created, the data showing and no problem.

but if everyone from my organization open the app, the data not showing.

 

I get the data from another powerBI dataset which is accessible to everyone in organization.

 

view if I myself open the app.

111111111111.PNG

 

view from visitor of my app

MicrosoftTeams-image (28).png 

3 REPLIES 3
RossEdwards
Solution Sage
Solution Sage

Permissions is likely the culprit. 

If the user didn't not have model access, you'd receive a different error. 

If the user did not have report access, it would not appear. 

If the user did not have app access, they would not get to this page.

This makes me suspect you are using Direct Query and the user does not have correct permissions at the data source.  I would try 1 of 2 solutions:

1.  Get the user access to the data source  (database level permissions)

2.  On the 'edit credentials' screen for this data source, uncheck "Report viewers can only access this data source with their own Power BI identities using DirectQuery".  Be aware this will bypass row-level security and might be an issue.

Hi Ross,

 

thanks so much for your reply. Im a total newb for this..

I have searched how to do the solutions that you give but can't find any instruction to do that. could you please help me again to find the instructions to do your solutions 

First thing to do is figure out if you are using Direct Query.  Open your model in Power BI Desktop and click on the data tab (left hand menu with 3 icons. Data is the middle icon that looks like a grid).

If you are in import mode, you'll see rows of data.  If you are in direct query, you'll get a message saying that.

 

If you are in direct query, identify the source that populates the tables that you can see but your user cannot.  Once you know where the data comes from, speak to the data owner about the permissions.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.