Data Loading issue in PowerBI desktop

[tajshaik]

Hi Team,

I am using powerbi desktop . as i tried to import an excel file it is opening a window and stucking . its not loading the data .

and sometimes it is not displaying the main interface options such as import.

please provide a solution for this.

[andrerochaslc]

Try to use the previous version, it will works..

https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-d...

[hnguy71]

ha, I thought it was just my machine! I would do the same to force close it and restart. 

[tajshaik]

please give any ideas to resolve this

[Greg_Deckler]

@tajshaik When this happens to me ( and it happens pretty frequently these days it seems ) I have to open Task Manager and kill every Power BI process. Then I restart Power BI and it generally works for a while, until it decides to do it again for no apparent reason.

[tajshaik]

@Greg_Deckler  Even i did Task manager thing . Even  after restarting the app it didnt work. Any other ideas how to resolve it?

[Greg_Deckler]

@tajshaik Are you on the latest version? Try turning off all of the Preview features. Restart computer.

[tajshaik]

yeah i tried everything but its not working.

[v-yiruan-msft]

Hi @tajshaik ,

First, please check if your computer can fulfill the following minimum requirements to run Power BI Desktop:

If the above one is OK, could you please try the following steps?

1. Update the version of your Power BI Desktop to the latest one

2. Please prepare a excel file with small size data or TXT file, then try to load the file into Power BI Desktop. Later check if it can be loaded successfully

3. Try to load the excel file into Power BI Desktop using other person's computer

Best Regards

[tajshaik]

it is showing white page instead of showing options in the middle

[v-yiruan-msft]

Hi @tajshaik ,

What's the version of your Power BI Desktop? Could you please share the excel file which you loaded into Power BI Desktop? Later we can try to load it in my side and check if it can load successfully or not...

Best Regards

[tajshaik]

https://drive.google.com/file/d/12-NRR7oSWf2td9sO4CxEHgkFbciBsX-R/view?usp=sharing 

can you check this video clip you will understand whats happening.

[v-yiruan-msft]

Hi @tajshaik ,

I watched your video, it seems like your Power BI Desktop load very slow. Again, please check if your computer fufill the minimum requirements to run Power BI Desktop.

Minimum requirements

In addition, the version of your Power BI Desktop is not latest one, please update it to the latest version.  Later check if the data can be loaded successfully after installed the latest version of Power BI Desktop.

Don't Get Left Behind: How to Easily Check Your Power BI Version

Best Regards

[tajshaik]

yeah same thing is happening with the latest version as well.

and my system is fulfilling the min requirements. but even though its not working

[v-yiruan-msft]

Hi @tajshaik ,

Could you please try the following steps?

1. Clear cache as below screenshot

2. Try to connect the data source other than excel file(for example: SQL Server) and check if it can load successfully

3. Uninstall Power BI Desktop and re-install it with the latest version

Best Regards

[tajshaik]

I am using latest version

Version:

2.137.751.0

and the data set that i am using

https://docs.google.com/spreadsheets/d/16wOh4oAf6Gstf-TGqIYnN-mHT13yEUhN/edit?usp=sharing&ouid=11020...  

[v-yiruan-msft]

Hi @tajshaik ,

I can't access to your shared file, could you please grant me the proper permission to access it? 

How to upload PBI in Community

Best Regards

[tajshaik]

I gave access now just check it .

https://docs.google.com/spreadsheets/d/16wOh4oAf6Gstf-TGqIYnN-mHT13yEUhN/edit?usp=sharing&ouid=11020...

[v-yiruan-msft]

Hi @tajshaik ,

I still not have the access to your shared file, you can refer the following link to upload the file in the community.

How to upload PBI in Community

Best Regards

[tajshaik]

When I did compatibility troubleshooting 

Once it worked normally for few minutes.

And then it started hanging again.

Is there anything that I should change any settings in my system?

[tajshaik]

I gave the access but I don't know what's the issue.

I tried with different data sets not even a single data set is loading.