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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors