I have Powerbi receiving all the records from a Jira project via a function. I then use another function to step through all the Keys and get their full changelog not just 40 per key. Has anyone gotten this right?
I can get my functions to work in PowerBI Desktop
But it fails in PowerBI Service when Publishing the report with error:
"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. Learn more: https://aka.ms/dynamic-data-sources."
It seems that if I have two exact URLS on another attempted scripts which feeds into the same table , I also get a Query firewall error stopping me from refreshing it locally even when changing the privacy. Which I believe will fail if I mark the datasource organizational or none in the Powerbi Service too.
Thank you for the help
