Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I have connected a SQL Azure Server to the Power BI Service using direct query. The issue I have is that when the developer makes changes to the database (adding new tables, views or columns) these updates are not pushed to the dataset on the service.
For me to see the updated data, I have to go through the whole process of 'get data' again. This would mean that all reports created using the existing dataset would have to be created again.
When i click on the ellipsis to the right of the dataset, i only have these options available: Rename, Remove, Dataset Settings, Analyze in Excel. when I select Dataset Settings > Dataset, there are no settings available for datasets that do not come from a file.
Thank you,
Elle
Solved! Go to Solution.
@elleneal yeah schema changes is not supported yet and that is a big impact. You should check out this idea submitted already for it and vote for it. Also look at some options discussed such as using power bi desktop instead to connect first to azure sql db and then publishing but i agree that is not the full alternative as well.
@elleneal yeah schema changes is not supported yet and that is a big impact. You should check out this idea submitted already for it and vote for it. Also look at some options discussed such as using power bi desktop instead to connect first to azure sql db and then publishing but i agree that is not the full alternative as well.
Thank you Ankit, this is a great help.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!