sara_sanchez
5 years agoNew Member
Status:
Needs Votes
Add folder specific filtering to SharePoint Online List connector (before connecting to data)
Now, the connector tries to retrieve all the information related to all the files and folders in your SharePoint Online List and, afterwards, you can use filters to keep only the files/folders you are interested in. This is extremely inefficient for big libraries, and you get time out errors after 5+ hours trying to connect to data. It would be nice to be able to select the folders from which you want to extract information before actually connecting to data, so that the connector sends the minimum necessary requests to the API. Due to this time out problem, we have had to resort to creating a custom connector that uses Azure Functions and Azure Data Factory to obtain the information from SharePoint, as explained in this blog article: https://www.clearpeaks.com/advanced-sharepoint-indexer-innohub/
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Allow calls of Fabric SQL Database stored procedures from Data Warehouse
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and even...Vojtech_Dolejsi1 hour agoNew MemberUnder Review2.9KViews13likes3CommentsAllow Data View access for tables sourced from external semantic models
When using DirectQuery for Power BI datasets or semantic model chaining, developers can use remote tables in DAX, relationships, and report visuals, but cannot inspect the underlying rows in Data Vie...kent_lewan10 hours agoNew MemberNew3Views0likes0CommentsDouble cost of licensing for admin users for Fabric Capacity Metrics
For our organization we have specific user accounts for admin work and normal accounts for normal work. We do have an F65 capacity, and for me my normal user account is licensed so I can create. I ...AaronGross10 hours agoNew MemberNew1View0likes0CommentsRefresh SQL Analytics endpoint activity in Fabric pipelines not working when deploying
Hi all, I noticed that the Refresh SQL Analytics endpoint activity is not saving the workspace id so when trying to deploy the pipeline which is using this activity, the deployment failed since the ...adrianrivas0713 hours agoNew MemberNew2Views0likes0Comments