cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bordt
New Member

Views not listed

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?

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

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

View solution in original post

1 REPLY 1
ankitpatira
Community Champion
Community Champion

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors