Forum Discussion
DirectQuery Scheduled Refresh to avoid Delays
Right now I have a dashboard in Power BI Desktop, where all the fields I have are using directQuery to acquire the data they need for the dashboard. This is causing the speed of the dashboard to become slower and slower. I was wondering if there is anyway I can fix this problem, so that the data on the dashboard loads in 5 seconds or less to be user friendly.
I need the data to be live which is why I'm using DirectQuery, but I was wondering if there is a way around this like using dual storage mode, or creating a second dataset that uses import mode from the direct query dataset. I would like to have the dataset be refreshed daily at around 3-4am so when user's run the dashboard during the day, there is no delay in the data loading. Not sure on the best way to go about this.
Hi Anonymous
Please check if below article could help.
For 3rd party Links:
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Regards,
2 Replies
v-cherch-msftMicrosoft Employee
Hi Anonymous
Please check if below article could help.
For 3rd party Links:
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Regards,
Thanks for the reply. I was also wondering if I create a dataset in power BI service and have it refresh say every hour, then make a dashboard in desktop that gets all its data from that dataset through the "get data from power BI dataset". Will this new dashboard experience any delays, since its only refrencing a dataset thats on a scheduled cache refresh in the service?