python vs dax

[Krcmajster]

Hi All, 

I currently have a bit problem with Power BI service lagging for people with slower internet and computers. There are a lot of visuals and dax measures.

My question is, will managing data and creating visuals with python speed it up?

[Mariusz]

Hi @Krcmajster 

If you are looking to improve the performance of your reports, you can start with Performance Analyzer ( new future in the View Tab ).

The Performance Analyzer will be able to highlight where is the issue ( eg. Visuals or DAX ), once you know the problem, you can start looking at solutions.
If you are using Power BI's built in visuals, this should be optimised already, so I don't think you will be able to improve much with Python.
What do you mean by managing data, are you thinking to prep data in query editor?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Krcmajster]

Thakn you for the reply @Mariusz 

Yes, I was thinking in running python scripts in querry editor.

[Mariusz]

Hi @Krcmajster 

Using Python in query editor could potentially improve the time it takes to load the data model ( data set ), this wold not have an impact on the responsiveness or the load of the report itself, I'm not a python expert but query editors M language should be optimised and fast enough as its native to Power BI, and can leverage municipalities like Query folding.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.