Select top 1 * in Source Database

[willchamp]

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.

[lbendlin · Accepted solution]

Power Query is renewing its meta data cache.