Forum Discussion
andreylabanca
6 years agoFrequent Visitor
Performance issues using pivoting on a small text file source
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 th...
Anonymous
6 years agoNot applicable
would you be able to share a sample or anonymised example file?
andreylabanca
6 years agoFrequent Visitor
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-msft6 years agoCommunity Support
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,
KellyDid I answer your question? Mark my post as a solution!