Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

BrandedSaiyan

Users Cannot Load Data for Visual - Couldn't Retrieve Data

Submitted by Advocate II on ‎10-21-2021 07:17 AM

I have users trying to load a report that uses a composite model getting the following error within the published app. When I view the report in the app or the workspace it loads just fine. We are not using RLS and I confirmed they still have acess to the app. I've refreshed the dataset, confirmed a different user (who also happens to be an admin) can open and load the report. Any ideas?

 

MicrosoftTeams-image.png

Status: Accepted
See more ideas labeled with:
7 Comments (7 New)
Comments
v-robertq-msft
Community Support
Community Support
‎10-21-2021 11:21 PM

Hi, 

If you want to get a solution for this kind of visual data problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

v-robertq-msft
Community Support
Community Support
‎10-21-2021 11:21 PM
Status changed to: Investigating
 
BrandedSaiyan
Advocate II
Advocate II
‎10-22-2021 06:37 AM

Thank you, I submitted a support ticket for the issue. It seems to be an issue just for the composite model and seems to correlate with this article being updated recently so there must have been a change.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

Anonymous
Not applicable
‎10-22-2021 10:24 AM

I might be having the same issue. A user cant get a visual to load and the error is non-descriptive like what you posted. Similarly, there is no RLS and it is a composite model in the sense that some tables are import and others are DirectQuery.

 

I just published another report that is in Dev that is composite with Import, DirectQuery, and another Power BI Dataset all in the model. This one does have RLS and when I try to view as a user in the Service I get a similar error that doesn't have any reasoning.

v-robertq-msft
Community Support
Community Support
‎10-24-2021 07:39 PM

Hi,

According to the link you posted, I can found a similar issue that has been reported internally, so stay tuned.ICM: 266081143

 

I will update here once I get any information.

 

Best Regards,

Community Support Team _Robert Qin

v-robertq-msft
Community Support
Community Support
‎10-24-2021 07:40 PM
Status changed to: Accepted
 
BrandedSaiyan
Advocate II
Advocate II
‎10-26-2021 08:31 AM

This is still an ongoing issue logged on support ticket 2110220040004248. Support has excalated this to the next tier, as they were unable to solve it. It's odd, for some users I can grant them admin rights to the workspace and this fixes the issue, for others it does not fix the issue. I let support know the tikcet you references, 266081143, and it appears that is for a postgres SQL connection. We are using a live power BI dataset connection with a local pbix table extended on top of it. 

Idea Statuses