Forum Discussion

Ajaal's avatar
Ajaal
Helper I
1 year ago
Solved

undefined

Hi ...  which one is better to be used as data source for powerbi dashboard?  a collection of excel files stored on sharepoint online or sharepoint lists?
  • christinepayton's avatar
    1 year ago

    It depends how you're using it. If you have a bunch of data you're just wanting to upload and reference, then Excel/CSV files is fine. If you want people to be actively editing the files and want more control over how they input the data and what they can do to your source, then SP lists are better. You can give users contribute access to the list, where they can edit/add data but not modify the list structure (which you want, because people modifying the list structure will often break things).