Forum Discussion

Oimat's avatar
Oimat
Helper I
1 year ago
Solved

Dynamic datasource for Sharepoint

Hello,  I manage 70 different Sharepoints. That list can vary each Sharepoints year, but they are all formatted the same. I do not wish to make 70 different queries and manage that by hand every tim...
Need Help
  • Oimat's avatar
    Oimat
    1 year ago

    Sadly it is not in my power to do that 😞

    I ended up using a Python script to generate 70 lines of query and appending all the tables... We'll have to update by hand when the list changes.

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi Oimat ,
Ensure that all SharePoint sites share the same credentials by centralizing authentication. If possible, assign a common service account with the necessary permissions across all sites. This approach simplifies access management and avoids authentication issues when dynamically connecting to multiple SharePoint sources in Power BI.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

Oimat's avatar
Oimat
Helper I
1 year ago

Sadly it is not in my power to do that 😞

I ended up using a Python script to generate 70 lines of query and appending all the tables... We'll have to update by hand when the list changes.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi Oimat ,
    We really appreciate your efforts and for letting us know the update on the issue.
    Please consider accepting your reply as solution so as to help other community members in the future who may face similar issue. 

    Please continue using fabric community forum for your further assistance.
    Thanks and regards