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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.