Forum Discussion
Cant Refresh Dataset
Hi Anonymous,
As the error message shows, the data source isn't supported. I would suggest you refer to dynamic-web-contents-and-power-bi-refresh-errors/ and using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/ and makr some changes.
Best Regards,
Dale
So the idea is to basically setup multiple queries... If you have multiple projects in Jira or different ticket types, create JQL queries to break down the pull into chunks. you will have then multiple tables. Be sure to generate the same columns and you can use the Merge Query function in Power Query to pull the items back into one Big table.
Of course you can "experiment" with the Power BI Service. If you are refreshing once a day then an hour long refresh may suffice. Although a lot can go wrong in an hour...
I have not looked into any kind of incremental refresh strategy, which could really help to cut down on the query time.
BTW.. This is where I got the 'code' to be able to schedule the refresh..