Skip to main content

Issues

Completed

Connect to Excel Workbook - "Workbook already exists - This workbook already exists on Power BI"

Vote (1) Share
Kristoffer Absalonsen's profile image

Kristoffer Absalonsen on 29 Sep 2016 21:22:03

When I try to connect to Excel Workbook on Onedrive for Business ( Power BI Service > Get Data > OneDrive for Business > Excel Workbook > "Connect" ), I get the following message, but it is not possible to find the report in the reports to the group:
"Workbook already exists - This workbook already exists on Power BI"



Connecting and removing the report has not been an issue earlier.

Comments (3)
Kristoffer Absalonsen's profile image Profile Picture

57e761db ce6f-4b83-af80-616ddb1ce07a on 05 Jul 2020 22:35:57

RE: Connect to Excel Workbook - "Workbook already exists - This workbook already exists on Power BI"

This happened to me more than once when moving an existing Excel file from the original location. When I tried to reconnect the Excel with PowerBI, I got this error message "This workbook already exists on Power BI". The Excel file is not visible in the Reports section, so I cannot remove any old reference to the file.

It seems to be an orphan reference issue. Any idea?

Kristoffer Absalonsen's profile image Profile Picture

cda9d1ec 00e5-436b-9ff7-3bb3c97096cb on 05 Jul 2020 22:31:37

RE: Connect to Excel Workbook - "Workbook already exists - This workbook already exists on Power BI"

Hi, thank you for looking into to it!

I'm not able to reproduce it with other excel worksbooks either. Is there a way to clear the cache in the Power BI Service?

Kristoffer Absalonsen's profile image Profile Picture

ac643e7c e800-ea11-a811-000d3a4f1ebb on 05 Jul 2020 22:31:28

RE: Connect to Excel Workbook - "Workbook already exists - This workbook already exists on Power BI"

Hello Kristoffer,
As i can not reproduce this can you create a support ticket at http://support.powerbi.com?
Thanks
Chuck