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.
Hi All,
The data loading is too slow in Power BI. I have tested with different systems and different database. Even it is getting hell lot of time using excel data with some 8k records.
Please suggest me as I am new to Power BI.
Thanks
Do you use the latest version of Power BI Desktop(2.47.4766.801)? Please change the Data Category of your fields(State and City) to “State or Province” and “City”, then check if data load faster in filled map.
If the issue still occurs, please share me your Excel file.
Regards,
Lydia
Thank you for your reply but still the same problem.
I have changed state to "state or provinance". I am using the below mentioned version of Power BI. I have shared the excel file for your reference. Data loading is too slow when I click on either drill down or drill up specially drill up.
Excel file: https://www.dropbox.com/s/z8mbqr774rjbet4/Superstore.xls?dl=0
Thanks
I change your Excel file from .xls to .xlsx, then use the latest version of Power BI Desktop(2.47.4766.801) to connect to the Excel file, create map as shown in your screenshot, data loading is fast when I click on drill up or drill down.
Please use lastest version of Power BI Desktop and change your Excel format.
Regards,
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.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |