Excel Table List, Property Columns disappearing

[JMARRIAN]

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, 

[v-junyant-msft]

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.

[JMARRIAN]

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.

[v-junyant-msft]

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.

[JMARRIAN]

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  

[lbendlin]

Try with a much shorter file path without funny characters.

[lbendlin]

Have you recently changed Power BI Desktop versions?

[JMARRIAN]

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)