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
