Power BI Desktop Data Loading

[shahbaz1]

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

[v-yuezhe-msft]

@shahbaz1,

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

[shahbaz1]

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 

[v-yuezhe-msft]

@shahbaz1,

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,