cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ericreiner New Member
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

Accepted Solutions
madion Occasional Visitor
Occasional Visitor

Re: unable to load data from SQL Azure

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.

 

 

8 REPLIES 8
mhenning Frequent Visitor
Frequent Visitor

Re: unable to load data from SQL Azure

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. 

Power BI Team jeffrey_wang
Power BI Team

Re: unable to load data from SQL Azure

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.

mhenning Frequent Visitor
Frequent Visitor

Re: unable to load data from SQL Azure

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

 

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

 

madion Occasional Visitor
Occasional Visitor

Re: unable to load data from SQL Azure

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.

 

 

mhenning Frequent Visitor
Frequent Visitor

Re: unable to load data from SQL Azure

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. 

Highlighted
Power BI Team TPalmer
Power BI Team

Re: unable to load data from SQL Azure

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

mhenning Frequent Visitor
Frequent Visitor

Re: unable to load data from SQL Azure

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

Sharon_Ruiz Visitor
Visitor

Re: unable to load data from SQL Azure

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