Forum Discussion
Making a data source disconnected to the report
Hi All,
I have report in which i have some very simple data sources like Excel and some complex data source like paginated API.
The paginated API takes a long time to refresh due to huge data coming through it. The problem I am facing is I use this report for doing some simulation by changing the excel data but when i refresh it refresh evrything and what i want is the API table are refreshed only once in a day and other data gets refreshed on demand.
I can think of two approaches but unfortunately not sure about the solution.
Approach 1: Make the data refresh configurable that ensure the particular table is refreshed only once daily.
Approach 2: Have another power bi report with export the data in question into a lets say a sharepoint excel automatically everyday and another report that consumes this data hence reducing the refresh time.
I hope this is clear. Any help will be highly appreciated.
Thanks
Anuj
4 Replies
- amitchandak
Super User
Anonymous , paginated report using power bi dataset ? and that is making it slow. or refresh in service slow.
I think you should use power bi dataset in the paginated report if that is not done as of now
HI amitchandak I using API to get data from JIRA, so not the paginated report but i need to call API in paginated form and dataset size that i m extracting is huge hence the refresh is very slow, hence i want to disassociate the refresh from the report for this data source
- jaideepnema
Solution Sage
Hi Anonymous ,
Have you tried connecting to the Power BI Workspace using XMLA End Point and refreshing the corresponding report's dataset ?
Here are the links for your help :
- Can you refresh a single table in Power BI? - YouTube
- Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs
- XMLA-Based PBI Dataset Refresh Automation – Insight Quest
So i would suggest you can process one table using XMLA End point with SQL Server Agent Job schedulled on a daily basis and manually refresh the other tables on demand.
Hope this helps !!
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
Thank you for the suggestion jaideepnema but the problem is tis works with Premium license and unfortunately I have Pro license 😞
