Invoked Function Refresh Not Working with bureau of labor statistics (BLS) Data

[Anonymous]

Hi All,

See attached. I have spent DAYS trying to figure out why this refreshes successfully once every 50 or 60 try’s but usually it times out and gives me the following error:

 

Notice it loads the first 264 rows of the invoked function… the problem is that sometimes it loads the first 1,000 rows so there doesn’t seem to be any consistency. The only thing consistent is that it doesn’t load all 2,000+ rows. It always get’s stuck somewhere and then throws the above error

Basically I have a list if Indices (Table is called “Indices List”) and I am invoking a function that goes to the Bureau of labor statistics (BLS) and pulls a table for each index. By invoking the function I am essentially just changing the last part of the URL to grab a different table.

Is this a bug or does Power bi just not have the ability to grab from this many URLS? What is weird is that if I were to keep trying 50 – 60 times then all of a sudden it refreshes.

Below is a link to the workbook. Thanks so much for any help you can offer.

BLS Indice PBIX Report

[Anonymous]

Hi All,

See attached. I have spent DAYS trying to figure out why this refreshes successfully once every 50 or 60 try’s but usually it times out and gives me the following error:

 

Notice it loads the first 264 rows of the invoked function… the problem is that sometimes it loads the first 1,000 rows so there doesn’t seem to be any consistency. The only thing consistent is that it doesn’t load all 2,000+ rows. It always get’s stuck somewhere and then throws the above error

Basically I have a list if Indices (Table is called “Indices List”) and I am invoking a function that goes to the Bureau of labor statistics (BLS) and pulls a table for each index. By invoking the function I am essentially just changing the last part of the URL to grab a different table.

Is this a bug or does Power bi just not have the ability to grab from this many URLS? What is weird is that if I were to keep trying 50 – 60 times then all of a sudden it refreshes.

Below is a link to the workbook. Thanks so much for any help you can offer.

BLS Indice PBIX Report

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

From your file, it could work normally on my side, could you have checked to get data form other environment? If the problem still persist, please create a support ticket here: https://powerbi.microsoft.com/en-us/support/pro/.

Regards,

Daniel He