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
willchamp
Frequent Visitor

Select top 1 * in Source Database

Hey everyone,

 

Just trying to understand what is happening when Power BI executes a select top 1 * from... query against our database. We're seeing it multiple times when someone executes a data refresh, but are not entirely sure what the purpose of it is. The report someone is using does not have any conditions like that in the semantic model, and is based entirely off of import data.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Power Query is renewing its meta data cache.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Power Query is renewing its meta data cache.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

Top Solution Authors
Top Kudoed Authors