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.
We have a dashboard which accesses two data sources, both of which are excel files containing about 500 and 5000 rows in each of them. But, when we access the dashboard online, not only it takes quite a time to load but also the page goes unresponsive when we try to access the filters. In my experience, this shouldn't be happening for a dashboard with this small a dataset and that too without a live connection. Could someone please explain why this might be happening?
Hoping that it is an intermittent issue.
Can you please check the below details.
1. Data Source (Local / Network Drive / Onedrive / Sharepoint - Excel)
2. Connectivity Mode - Import / Direct Query
3. Gateway - On-premises/Personal
4. Gateway Version - Month and Year.
Note:- Always try to maintain latest version of the Gateway.
https://www.microsoft.com/en-us/download/details.aspx?id=53127
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?
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.