Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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,
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.