Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to stop getting a dynamic data source error when connecting to a website

I've started creating a report in Power BI desktop, so far I'm just collecting the data. It uses yahoo finance to retrieve historical index values. It works perfectly in Power BI Desktop but when I publish to Power BI service I'm unable to refresh the data. I get the error message: "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed."

Does anyone know how to stop this?

This is the report: https://drive.google.com/file/d/1tQz-TBG_E5CKZ878AVayZqdXBtO2YHUK/view?usp=drive 

 

These are the queries:

EpochTime - this connects to the website https://www.epochconverter.com/ to retrieve the current epoch time

Index Parameter - this is a parameter that downloads the data from yahoo finance. There are two parameters plugged into the url to get the correct dates and company ticker.

InvokedFunction - This brings everthing together and invokes the previous parameter table to bring in the data for the companies listed

IndexValues - this gets everything into the correct format that I'll need it in. I don't think the problem is here, I think it's in the tables that get data from the web

Index Selection - This can be ignored, it's used in something else

 

Hopefully someones had an error like this before and knows a way it can be solved. Thanks

 

 

 

 

 

1 Reply