Direct Query after publishing from Power BI Desktop

[jamesdales]

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

Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net

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

[ankitpatira]

@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.

[jamesdales]

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