Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Direct Query Connection with SharePoint Online

Hi there,   Is there a work-around in creating a direct query connection in Power BI when using SharePoint List Online?   Thank you
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    You will find the acceptable Direct Query data sources here

    The idea for this has not been commented on by the PBI team, but you can add votes to it here

     

    Here's a blog post that describes the use of a 3rd party tool (AxioWorks SQList) to synch the SharePoint lists with normalised SQL Azure tables which then gives you the option of direct query. 

     

    Since SQList updates SQL Azure as soon as SharePoint changes are made it is a very nice workaround for Direct Query

     

    Power BI direct query workaround for SharePoint

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks TomMartens , am not sure my organisation will want to pay for this. But atleast there is something out there incase they change their mind.

     

    Regards