October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hello I have an SQL database running in Azure.
To this I connected the Power BI service. That all works fine.
Now I added an SQL view in the database. But this view does not get listed in Power BI by doing a refresh.
It only appears if I make a new connection to the database. But with this I loose any report I build in Power BI, as this report is linked to the previous database connection.
How can the database connection be refreshed to list any table, view changes made to the database in Power BI?
Solved! Go to Solution.
@bordt metadata changes (new tables / views) are not included in data refresh. Since you've built the report using power bi service you can't edit its dataset to include extra views or table (unfortunately have to redo report with new views). You should typically use power bi desktop to build reports and then publish to service. If report was done through power bi desktop then you can edit pbix file via query editor to include new views and republish that report.
@bordt metadata changes (new tables / views) are not included in data refresh. Since you've built the report using power bi service you can't edit its dataset to include extra views or table (unfortunately have to redo report with new views). You should typically use power bi desktop to build reports and then publish to service. If report was done through power bi desktop then you can edit pbix file via query editor to include new views and republish that report.