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 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, 

 

Need Help

7 Replies

    • JMARRIAN's avatar
      JMARRIAN
      Regular Visitor
      2 years ago

      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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years 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
      2 years 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
        2 years 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