Connecting Confluence to Power BI

[gaganmeet13]

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

[v-yiruan-msft]

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