I have quite a large data set and some complex queries. About a week ago it all started to slowly unravel. When looking in DAX studio the size of my data is 1GB (and it is increasing at 1% per day!!) The data set is no longer refreshing it is timing out in the power bi service The data sources ar…

Hi @ells , Alright. Thanks for that. Paste this into a new blank query and give it a name like: ListDates let Source = #"Dim Calendar"[[skey_date], [Fiscal Year Offset]], SelectDates = List.Buffer( Table.SelectRows(Source, each ([Fiscal Year Offset] = -1 or [Fiscal Year Offset] = 0))[skey_…

Tuning Power query performance

Power Query

Melissa March 4, 2021, 11:45am 2

Hi @ells,

Imke Feldmann has a collection of tips on how to improve performance of your M-queries.

1 Like