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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nuno_m_duarte
Frequent Visitor

Error changing to Mixed storage mode

Hi.

We have a composite model report with a connected live to one dataset in Power BI Service and a table with some measures. It's been working fine so far, but today gave an error, in visual detalis "Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.".

I tested it on desktop, add power bi service dataset, work fine, but when i click on "Make changes to this model" it gives de error: "Either the database 'dataset' does not exist, or you do not have permissions to acess it. 

 

Best ragards,

Nuno Duarte

4 REPLIES 4
Anand24
Super User
Super User

Hi @nuno_m_duarte ,
Please check the authentication type of the already published dataset. Please check if anything has been changed since yesterday. 
The issue seems to be at the published dataset end where authentication is failing. Hence it is throwing the "Couldn't retrieve data" error in services.

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

 

I Install in another tenant and do the same and work fine.

@nuno_m_duarte ,
I feel logs needs to be checked for debugging this.

It would be best if you can raise a support ticket and get dedicated query solution since they can compare both(where it is working and where it not working) tenants or multiple users through logs and give you the exact solution.

PBI_SuperUser_Rank@1x.png  

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

Hi @Anand24 ,

 

The dataset is from an App Template. I install again the app in another workgroup, make a refresh and work fine. Then i refresh by schedule and stop working with the same problem. I have this app in dozens of customers and never had this problem.

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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

Top Solution Authors