cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors