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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Petsnell
Helper I
Helper I

Dataset missing in Excel

After what seems to be an update of Excel to (Version 2305 Build 16.0.16501.20074) 32-bit with the new feature for "Insert Table", one of our datasets mysteriously dissapeared from the list. I am not aware of any other changes, and the error message when I try to update existing connections is inserted below.

 

Has anyone else experienced this or may provide suggestions on how to solve? When I use an older Excel, (Version 2208 Build 16.0.15601.20742) 64-bit, everything still works like a charm... The "Insert Table" function is not available there. 

 

Petsnell_0-1694160308467.png

 

1 ACCEPTED SOLUTION
Petsnell
Helper I
Helper I

Such a silly mistake - the preview pane only shows a handful of datasets, I had to search and press enter in the search field to find the one I assumed missing...

 

However, this does not explain the error message when I try to update. 

View solution in original post

1 REPLY 1
Petsnell
Helper I
Helper I

Such a silly mistake - the preview pane only shows a handful of datasets, I had to search and press enter in the search field to find the one I assumed missing...

 

However, this does not explain the error message when I try to update. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.