Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gaganmeet13
Regular Visitor

Connecting Confluence to Power BI

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

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

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)

yingyinr_0-1655360233104.png

Visualize Live Confluence Data in the Power BI Service

yingyinr_1-1655360267760.png

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.