March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I have been trying to get data from a confluence page of our company portal to analyze it in Power BI but after multiple attempts I haven't had any success.
I downloaded the custom connector (by CDATA) which gives you the content of a page in the HTML form but I don't know how to get that into table form.
Can anyone help me with this? Will really appreciate any help.
Regards
Gaganmeet singh Dhir
Hi @gaganmeet13 ,
You can refer the following links to get it.
View Reports on Real-Time Confluence Data in Power BI Report Server (Get Data -> ODBC)
Visualize Live Confluence Data in the Power BI Service
Power BI failed to connect to Confluence Cloud page with web connector
Using Power BI to access data within Confluence is a great idea. However, Confluence will require authentication through the portal to allow for viewing of the contents of pages. This means you won’t be able to connect using a web connector with credentials within Power BI.
Another option would be to access Confluence via the REST API. You can find more about the Confluence REST API within the documentation. There is also a Power BI community post about accessing data from Atlassian products via the API. This example uses Jira, but the method used will be similar for access Confluence. You may find that post at https://community.powerbi.com/t5/Desktop/Get-data-from-Jira-Rest-API/td-p/516130.
I hope this sheds some light on accessing data within Confluence through Power BI and provides options moving forward. When you able to gain access to the data, please let us know what you did so other may learn from your adventure!
Best Regards
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |