Forum Discussion
Direct Query Connection with SharePoint Online
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 , I did not remember anything like that. But refer if this feature can help
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2020-feature-summary/#_APR
Thank you amitchandak for this, do you think this will update the dashboard in Power BI Service?
Hey Anonymous , hey amitchandak ,
automatic page refresh will only work with datasets in directquery mode:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#:~:text=Table%201%20%20%20%20Storage%20mode%20,interval%3A%20%20...%20%201%20more%20rows%20As Sharepoint lists can not be accessed using directquery, Automatic page refresh will not be available.
Regards,
Tom
Thanks a lot mate, that clears it up.
