Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.