Is the Sample File within the Transformation File needed?

[nmyre]

I am trying to optimise the tool I made. It is great, but is pretty slow. I am looking for ways to cut out anything I do not need or porcess improvments that will help it run faster.

I know that the Transformation file as a whole has its purpose, but the sample file within it seems unneccisary.

Any insight into the file or optimization would be great.

Thanks.

[Anonymous]

Hi @nmyre ,

Not very clearly ...

Maybe you could take a look at this blog:

https://www.fourmoo.com/2017/05/02/what-makes-up-a-power-bi-desktop-pbix-file/

Best Regards,
Eyelyn Qin

[amitchandak]

@nmyre , The information you have provided is not making the problem clear to me. Can you please explain with an example.

There are many aspects on performance

refer

https://www.thebiccountant.com/speedperformance-aspects/

or

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Rel...
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-sho...

Appreciate your Kudos.

[nmyre]

@amitchandak Sorry, not terribly clear. Here is a snippet of the Power Query edditor.

The Transform Sample File (48) is what I am looking at. Is that sample file needed or will it affect the file/query at all?