Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Employee
Employee

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
Employee
Employee

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

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors