cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
noahh Frequent Visitor
Frequent Visitor

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

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:

 Error Picture.jpg

 

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

Refresh Picture.jpg

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Invoked Function Refresh Error for web data

Hi @noahh,

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

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
noahh Frequent Visitor
Frequent Visitor

Invoked Function Refresh Error for web data

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:

 Error Picture.jpg

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

Refresh Picture.jpg

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

Community Support Team
Community Support Team

Re: Invoked Function Refresh Error for web data

Hi @noahh,

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

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.