Performance issues using pivoting on a small text file source

[andreylabanca]

Hi Guys, a noob question here.

I'm having some trouble with unpivoting and then pivoting some columns in my table. The source file is very small (40MB) and the pbix file too (2.5 MB). Right after the unpoviting step every simple action in the data model take 3 to 8 minutos loading (like changing a column type). To apply any changes take something like 10 or 30 minutes.

I really can't understand how such a small database (72,000 rows and 15 columns) is so slow after using pivoting. I'm running the Power BI Desktop on a reasonable computer and neither memory, disk or cpu are compromised.

The months I need for my model are in the column names of my data source. Something like "Budget Jan" Budget Feb "etc. That is why I am using unpivot and then pivoting again to replace the original column names without the months in them.

Anyone knows if this is a really slow operation by default or I'm doing something wrong? Thanks in advance.

[Anonymous]

would you be able to share a sample or anonymised example file? 

[andreylabanca]

https://1drv.ms/u/s!AoGW_VUgOfOvjsQRI2x71W3r7_t6rw?e=SLsnuF

This is an example pbix that contains the base that I'm having problems with unpivoting / pivoting.

In the original project there are several other queries that reference this original making the performance even worse.

[v-kelly-msft]

Hi  @andreylabanca ,

I can't open the .pbix file with your link,since the data source is from your local site,could you pls take some screenshots about your issue and paste the codes in advanced editor.

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!