Refreshing a file that adds a column every day

[Anonymous]

Hi folks , I have a file that adds every day a new column and I want to refresh that file every day using the Gateways . But I'm having the problem on refreshing , power bi seems to be unable to add more columns  that those who were imported initially to the queries.

Can someone help me ?

Thank you 🙂 

[v-chuncz-msft]

@Anonymous ,

You may try Unpivot Other Columns in Query Editor and use Matrix visual later.

[Anonymous]

@v-chuncz-msft 

[Anonymous]

It didn't helped me . I still have the same problem that is trying to automate the refreshing of that table . Because if Power query only strores 5 columns which was the number of columns of the first time I added it to the project . So if I unpivot the columns I will be only unpivoting 5 columns ... The problem is on the source .