Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

New table to imported Excel dataset

Hi all,   I have created a dataset by importing an Excel file with one defined range from a SharePoint Team site. This works and is refreshed as I change the data.   I would like to be able to ad...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

Which mode you use to connect excel file? Upload or import? If you are works on import mode, I don't think these imported contents can synced changes which you apply on excel workbooks.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    I'm using Import and it is syncing the data when I update it. It is just not picking up a new table/range that I have added.

     

    Regards,

    Óskar Friðrik

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI Anonymous ,

      Import will cache excel date structure to dataset. For power bi dataset, its data structure not able dynamic changes.
      You need to import new excel file to replace cached data structure, otherwise only original data fields will been updated.(new fields not auto added to dataset)

      Regards,

      Xiaoxin Sheng