- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excel Table List, Property Columns disappearing
I have a number of Excel FIles which all have an indentical structure. The all have the same queries and the same named ranges. I have checked and all the queres have the same privacy setting of Organizational.
Previously the File Contents would display like this.
And recently the file contents displays like this. Which is missing the Columns for Item, Kind and Hidden
The result is that all the Power Queries that used to work are now breaking. If anyone can help me crack this case it would be hugely appreciated,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @JMARRIAN ,
I would recommend that you reconnect after clearing your data source credentials to see if the problem persists to troubleshoot if this is a temporary issue.
Additionally, I tested Power Query in these two versions of Power BI Desktop below, and neither found the same problem:
If the problem persists after reconnecting, please try uninstalling Power BI Desktop and download the two versions I tested and try again.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your kind suggestions. I am using the same Version: 2.132.1053.0 64-bit (August 2024)
I followed your recommendation and cleared the data source credentials in the Source Excel file and redoing them ensuring they are all set to Privacy= Organizational.
Now i am faced with this error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @JMARRIAN ,
May I ask you when this version 2.132.1053.0 64-bit (August 2024) was downloaded? This version was reported by multiple people a few days ago to have some issues that could potentially cause this problem. My own test environment is the latest version that was just downloaded today and is fine, if so, could you uninstall the current version and reinstall it.
If the problem still exists after uninstalling and reinstalling, it may be a problem with your data source. According to your error message, please check whether there are shared queries between multiple excel, or whether there are some excel files created by referencing other excel.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am convinced the problem relates to the Source Excel files. Because if I query an older excel file I do not have any problems. However if I refresh all the queries in that very same source file and then save it. I then have problems, despite not have made any changes other then refreshing the existing source file queries.
I have also tried rebuilding my PBI query and i observe the same problem, for some reason refreshing the Source Excel file queries is leading to an issue in the PBI Query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with a much shorter file path without funny characters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you recently changed Power BI Desktop versions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for engaging with the challenge, I think its safe to assume the Power BI Desktop version has recently changed. I check the current version which is Version: 2.132.1053.0 64-bit (August 2024)

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
11-17-2023 02:42 AM | |||
12-03-2023 04:26 AM | |||
03-29-2024 03:10 AM | |||
06-07-2024 05:17 AM | |||
10-29-2022 10:51 AM |
User | Count |
---|---|
27 | |
25 | |
25 | |
13 | |
9 |
User | Count |
---|---|
24 | |
19 | |
16 | |
13 | |
10 |