Stuart_Waller's avatar
Stuart_Waller
Regular Visitor
1 year ago
Status:
New

Enable Direct Query connections for SharePoint Files/Folders/Lists in Power BI.

Currently, Power BI can only connect to SharePoint data sources in Import mode only.
I need to connect to SharePoint sources in Direct Query mode, for the same reasons I need to connect to other sources in Direct Query mode.

The viewer has no way of refreshing the data as this functionality is not available to non-admin users, and this is a problem.

Refresh schedules can only run in 30 minute increments and are a pain to setup in this way as it invovles creating 48 refreshes, rather than just providing a single option for Half-Hourly refresh.

1 Comment

  • I think it will be a great implementation for Power BI. At least Sharepoint lists sould connect into direct query, since they are more structured then files and folders

Recent ideas