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
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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors