Forum Discussion

IPGeorgiev's avatar
IPGeorgiev
Helper III
6 years ago
Solved

Index Column - separately for each file

Hi all,   I have a dataset where the data source is a folder. This folder has multiple excel files with the same type of Raw data , but for different periods.   In order to achieve what I want I ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Yes, edit the query for the sample file and add the index there. You want the Transform Sample File query. I have attached an example PBIX.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Yes, edit the query for the sample file and add the index there. You want the Transform Sample File query. I have attached an example PBIX.

john121's avatar
john121
Frequent Visitor
3 years ago

Hi Greg,

Could you reupload the file as it is giving  data source error.

Thanks!