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
ericreiner
New Member

unable to load data from SQL Azure

I have been trying to use PowerBI with an Azure database.  PowerBI can see my table structure but always gives an error trying to retrive data, making the tool useless.  The error I keep getting is:

Couldn't load the data for this visual
 
Couldn’t retrieve the data for this visual. Please try again later.

 

Activity Idc6714063-d785-4cd1-927a-ea65c677f492
TimeWed Jul 22 2015 12:35:01 GMT-0500 (CDT)
Version11.0.9167.446

 

I did try upgrading the level of the Database to see if that was the error but right now it is at a S0 and still does not work.  Any clues on how to get PowerBI to read the data?

1 ACCEPTED SOLUTION

I have fixed this issue by changing my date columns from date to datetime and then re-creating the dataset (I still haven't figured out how to refresh a SQL Azure schema?!)

 

ALTER TABLE [tablename]
ALTER COLUMN [columnwithdateformat] datetime

 

Thanks for the previous posts as the error message doesn't give any indication on what's wrong.

 

 

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

I had a similar error, and the cause was a semicolon at the end of one query added by a formatter.

Sharon_Ruiz
Regular Visitor

Having the same issue...is there any resolution? 

mhenning
Frequent Visitor

I am getting the same issue. I confirmed that the firewall settings on the Azure SQL server were set to "on" for "Allow access to Azure services"

 

I have confirmed there is data in my database and table, power BI can see the table and columns, but will not load any of the data for some reason. 

There is a bug that's fixed recently. It will take a couple of weeks for the fix to propagate through several stages of testing. If your case is urgent, please file a support incident. The bug manifests itself when an Azure SQL table contains columns of certain datetime data types, an incorrect query is generated to map the table into Power BI.

Can I modify the DATETIME data type to get this working?

 

I submitted a ticket to get this working, how long will it take?

 

I have fixed this issue by changing my date columns from date to datetime and then re-creating the dataset (I still haven't figured out how to refresh a SQL Azure schema?!)

 

ALTER TABLE [tablename]
ALTER COLUMN [columnwithdateformat] datetime

 

Thanks for the previous posts as the error message doesn't give any indication on what's wrong.

 

 

FWIW .. I prefer to use a view, since I push data into a source table using a scheduled job. I found I can make small changes to the view, and it reflects in the reports. I cannot change the schema, or data type though. That is very frustrating. I was able to alter a view and use select case to change some of the data going into powerbi. As long as I stick with the same datatype, the report handles it fine but changing from an integer to a varchar and power bi cannot handle it. I have to delete then re-add the dataset to grab the changes. 

Thanks for the feedback, we are looking to improve the connector so that things like schema changes don't require you to recreate the connection. It would be great if you could add your votes to the suggestion as well:

 

https://support.powerbi.com/forums/265200-power-bi/suggestions/8521726-allow-schema-refresh-for-sql-...

Please add this. the schema changes thing is KILLING me. 

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