Forum Discussion
Excel: Power Query
I have the following Excel Power Query: let
Source = Sql.Databases("MyConnectionString.datamart.fabric.microsoft.com"),
MyDatabase = Source{[Name="MyDatabase"]}[Data],
MyExcelQuery = MyDat...
There are multiple users of the report this spreadsheet contains. Forcing a re-query by simply cutting/pasting the power query statement appears to be a universal workaround. Clearing the cache doesn't do that much.
What I'm wondering is what the root cause might be? For example: I'm wondering if an upstream schema change which then arrives in a datamart isn't picked up by the (very simple) query?