Forum Discussion

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