Vipul Shah on 26 Sep 2016 10:41:41
With large volume of data in SharePoint List, it takes forever for a scheduled/on-demand refresh as it refreshes everything from scratch. It would be nice to support direct query (live query) against SPO List. Customer is expecting to see real-time dashboard change when item is updated in SPO list.
- Comments (56)
RE: Direct Query for SharePoint List
Much much needed
RE: Direct Query for SharePoint List
VOTING FOR THIS! Would be very helpful!
RE: Direct Query for SharePoint List
This would be very helpful for us, please consider this one.
RE: Direct Query for SharePoint List
This would be really useful for my organization since SharePoint is one of our primary platforms for data storage and sharing. Not only would this help with large file sizes, but integrating a Power App into a Power BI report for user entry purposes requires a direct query connection to the table storing the user entries. It would be extremely useful to be able to use a SharePoint list for that source!!!
RE: Direct Query for SharePoint List
Voted, would be super useful
RE: Direct Query for SharePoint List
The hourly(ish) OneDrive cloud refresh is not frequent enough and the 30 minute frequency on Premium Capacity can consume a lot resources if not used wisely. Having a direct query option to SP online would open up a significant amount of possibilities for real time business oversight using Power BI, especially for organizations that rely on SP as their primary data platform.
RE: Direct Query for SharePoint List
This opens up a lot of interactive possibilities for reports. It is very easy and cool to associate a powerapp with a record in a table, unfortunately there is a long refresh delay to see the changes in powerbi if that is populated into a sharepoint list.
RE: Direct Query for SharePoint List
Crucial
RE: Direct Query for SharePoint List
Voted.
RE: Direct Query for SharePoint List
Much needed. voted