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
Preserve Power BI Semantic Model Measures and Business Metadata When Generating Fabric IQ Ontologies
When Fabric IQ generates an ontology from an existing Power BI semantic model, it should preserve more of the business semantics that organizations have already invested in defining. Today, a semant...