Stuart_Waller
1 year agoRegular Visitor
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
- VictorFantNew MemberI 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
Support VNet data gateway connections in Power BI Report Builder (Get data / Power Query)
Power BI Report Builder can't use a VNet data gateway connection. In Get data (Power Query), the Data gateway field shows "none" and can't be changed, so the query goes straight to the source over th...ilia_ryzhkov5 hours agoNew MemberNew15Views2likes0CommentsOption to set custom width for gridlines OR fixed outer padding
When designing reports, using the align and distribute evenly options in the format pane are useful, however when designing report pages with fixed bleeds between visuals I have to follow these steps...IolaWhiteley13 hours agoAdvocate IINew3Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell14 hours agoNew MemberNew22Views2likes1CommentOption to Stop Fabric Planning Billing Session After Plan Item Deletion
Currently, a Fabric Planning session remains active for 30 days once triggered. If a user creates a Plan item only for testing and deletes it the next day, the billing session still continues and c...v-dugumarrir115 hours agoMicrosoft EmployeeNew47Views11likes1Comment