Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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?
Solved! Go to 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.
I had a similar error, and the cause was a semicolon at the end of one query added by a formatter.
Having the same issue...is there any resolution?
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:
Please add this. the schema changes thing is KILLING me.