Forum Discussion

PetterR's avatar
PetterR
Icon for Helper I rankHelper I
3 years ago

Connecting Power Query to SharePoint Online list with more than 12 lookup columns

Dear all,   for consolidating different data sources in a Power BI report I need to connect to a SharePoint Online list, which currently includes more than 12 lookup-table based columns (mainly peo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi PetterR  - sorry I did a bit more research.  This is an issue for PowerApps as well.  Could you switch from using SharePoint to using a Dataverse table?

  • PetterR's avatar
    PetterR
    Icon for Helper I rankHelper I
    3 years ago

    Hi Anonymous , the data we want to connect to is maintained in SharePoint; I'm not sure if this information is also mirrored in Dataverse table, if so, I can definitely connect to that. However, changing data entry from SharePoint to Dataverse would be a process change on the business side.