Forum Discussion

Krcmajster's avatar
Krcmajster
Helper IV
7 years ago

python vs dax

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...
Need Help
Mariusz's avatar
Mariusz
Community Champion
7 years ago

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.
Mariusz Repczynski

 

Krcmajster's avatar
Krcmajster
Helper IV
7 years ago

Thakn you for the reply Mariusz 

 

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

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    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.
    Mariusz Repczynski