Refresh data from Python stuck in "Evaluating..."

[Anonymous]

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?

[v-shex-msft]

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

[Anonymous]

Hi, thanks for your answer.

I use python because i need to make a loop to the api for paginate.

The version I have is:

Versión: 2.108.603.0 64-bit 

after a long time it only show this message:

as i wrote before, the script used to work but suddenly it get stuck. in evaluating.

Thanks!

[v-shex-msft · Accepted solution]

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:

Chris Webb's BI Blog: New Options For The Table.Buffer Function In Power Query Chris Webb's BI Blog (crossjoin.co.uk)

Regards,

Xiaoxin Sheng

[Anonymous]

Hi. I have been searching for examples of the use of getNextPage for API, but can't find it.

Do you have any example?