Forum Discussion
Refresh data from Python stuck in "Evaluating..."
Hi.
I have an issue trying to refresh data from a python script.
The script I use is an API integration from Pagerduty to Power bi, and it used to work, but now it get stuck in "Evaluating..." for hours!
this is a script i didn't run since january, so i think could be an update from Python or Power Bi which is creating this problem
The script is the one in this link:
https://community.pagerduty.com/forum/t/integration-with-powerbi-for-dashboarding/1940/14
I followed all the instructions from docs. (https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts)
I already reinstalled Python (with pandas, matplotlib)
Has anyone had something similar happen?
Hi Anonymous,
In fact, power query also supports paginated API, you can take a look at the helper function if helps:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Docs
In addition, you can also take a look at the buffer functions if your scenario is related to the memory spent on looping calculations:
Regards,
Xiaoxin Sheng
4 Replies
Hi Anonymous,
I'm not so clear why you nested use data connector and python script to get data, which version of power bi desktop are you tested? Can you please share some more detail?
How to Get Your Question Answered Quickly
BTW, current power bi can directly use a web connector to get data from the rest API.
Solved: Pull data from RESTful API with token authenticati... - Microsoft Power BI Community
Regards,Xiaoxin Sheng
Hi Anonymous,
In fact, power query also supports paginated API, you can take a look at the helper function if helps:
Helper functions for M extensions for Power Query connectors - Power Query | Microsoft Docs
In addition, you can also take a look at the buffer functions if your scenario is related to the memory spent on looping calculations:
Regards,
Xiaoxin Sheng