Forum Discussion
ZaiChC97
1 year agoNew Member
Can I connect MS Loop to Power BI?
I'm currently exploring ways to connect Microsoft Loop with Power BI to visualize data that is collaboratively created in Loop components (like tables or checklists). So far, I haven't found any nati...
- 1 year ago
Try the SharePoint Folder connector, or the Graph API
Overview of Copilot Pages and Loop workspaces storage and permissions | Microsoft Learn
StevenS
Advocate I
5 months agoZaiChC97 It's not explicitly mentioned by lbendlin , but Microsoft Graph/SharePoint has an API which can export the .loop contents as HTML, which can then be imported into Power BI using PowerQuery.
See the code below for a example that has worked for me.
*Replace the [[placeholder values]] for your SharePoint environment and Loop File
Source =
Binary.Buffer(
Web.Contents(
"https://[[your.sharepoint.com]]/_api/v2.1/drives/" &
yourSharePointDriveID &
"root:/[[pathto/yourfile.loop]]:" &
"/content?format=html"
)
),
LoopContents = Web.Page(Source) // Alternatively, use: Html.Table(Source, ... ) Combine the above with scheduled refresh/Power Automate flow, and your loop contents can be kept up to date as changes are made.
See also an idea you can vote for.