cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ashokpershad Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: Connection lost between excel file and power BI service

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
Moderator v-caliao-msft
Moderator

Re: Connection lost between excel file and power BI service

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

bonny666 Regular Visitor
Regular Visitor

Re: Connection lost between excel file and power BI service

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!

 

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,281 guests
Please welcome our newest community members: