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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

Direct Query after publishing from Power BI Desktop

Hi we have a number of reports for a client that have been built in Power BI desktop connecting to an Azure SQL Database. These work fine in Desktop.

 

When I publish to the Power BI service they do not work and all visuals return.

 

Couldn't load the data for this visual
 
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support and provide the following details to help resolve your issue faster.

 

Activity ID5080f61c-380b-9a3a-3a55-1facdc548768
Request IDdf6f179b-b442-9f89-db99-4f4d141c217e
Correlation ID04835f5e-1beb-c899-683b-92f3c91d8f1a
TimeThu May 12 2016 13:01:06 GMT+0100 (GMT Summer Time)
Version13.0.1100.519

 

Credentials have been entered etc within the service.

 

If I use the Get Data button and create a new connection within the web service, this works fine.

 

Any ideas gratefully received.

 

Thanks,

 

James

2 REPLIES 2
ankitpatira
Community Champion
Community Champion

@jamesdales

For the published dataset can you troubleshoot it by refreshing it or using it to create new visual. That way we can determine if the problem is connecting from service to azure or something else.

Hi

 

If I hit refresh, I continue to get the error message.

If I use the dataset to create a new visual then this results in the error.

 

Since posting the original issue, I've created a new Power BI desktop report based on similar data (and data types) hosted in a different Azure subscription, published in the same way, and that works ok.

 

Just to confirm - I have the "Allow access to Azure services" set to "ON".

 

Thanks,

 

James

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors