cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashokpershad
Advocate II
Advocate II

Connection lost between excel file and power BI service

Hi!!
Recently i have created one excel file which i placed in One drive for Business. I have used this file to develop reports and Dashboards from Power BI web service.
Yesterday while working on the One Drive, by mistake I CUT and PASTE same file to Sharepoint. I corrected my mistake and placed same file back to One drive for business (without any modification). After this instance i updated some of the contents in same file and tried to refresh the Power BI reports/datasets but it is not updating in power BI service. For your information, I am not getting any error message for connection lost but same time nothing is updating.
Kindly suggest what can be done to bring the connection back as i have spent whole lot of time in preparing this report and Dashboard.

Thanks

------------------------------
Ashok Pershad
Process Analytical Specialist
(ASQ - Six Sigma Black Belt)

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft
Microsoft

Hi @ashokpershad,

 

I have tested it on my local environment, I can reproduce this issue. Based on my research, the report data source connect to the original excel file which is not existing on your one drive, so you get this issue. Currently, if you dellete the original excel file by mistake, you need to re-connect to it the excel file and create your report manually. Thank you for your understanding.

 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

 

 

View solution in original post

2 REPLIES 2
bonny666
Helper I
Helper I

Hello,

 

I think I have the same issue now.

 

Just stopped trying to refresh and nothing I can do about it.

 

I have about 10 reports based on this one dataset. if I will delete and reimport it, I will have to recreate all the 10 reports??

 

Please advise how you solved it. it will help me a lot.

 

Thanks!

 

v-caliao-msft
Microsoft
Microsoft

Hi @ashokpershad,

 

I have tested it on my local environment, I can reproduce this issue. Based on my research, the report data source connect to the original excel file which is not existing on your one drive, so you get this issue. Currently, if you dellete the original excel file by mistake, you need to re-connect to it the excel file and create your report manually. Thank you for your understanding.

 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

 

 

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!