Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.