Forum Discussion

JMARRIAN's avatar
JMARRIAN
Regular Visitor
2 years ago

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 Orga...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
JMARRIAN
Regular Visitor
1 year ago

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.

 

 

  • JMARRIAN's avatar
    JMARRIAN
    Regular Visitor
    1 year ago

    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's avatar
      lbendlin
      Super User
      1 year ago

      Try with a much shorter file path without funny characters.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.