Forum Discussion

Syndran's avatar
Syndran
Frequent Visitor
6 years ago

Power Query internal evaluation loops

I have a small table loaded from an excel file.  Table is 3 columns and around 30 rows, total size is <50k This table has existed for a long time, but in the last few days has caused my data refre...
Need Help
Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello Syndran 

 

you can try this out

let
Source = Excel.Workbook(File.Contents("\\XXXXXXXXXXXX"), null, true),
    #"Activity Keys_Sheet" = Table.Buffer(Source{[Item="Activity Keys",Kind="Sheet"]}[Data]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Activity Keys_Sheet", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Team", type text}, {"Activity", type text}, {"Activity Type", type text}}),
in
    #"Changed Type1"

 

let us now if it had some impact


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Syndran's avatar
Syndran
Frequent Visitor
6 years ago

Sadly no impact. 
sometimes the query is fine, runs/completes in <5 seconds, sometimes it sits there thrashing itself to death for 40 odd minutes.
remade excel sheet, remade connection, same thing.

Currently my data model, all 60 meg of it, is taking up 19 gig of memory, trying to reactivate a relationship that I set inactive, seems the issue is in powerbi not the model.