Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Power BI fails to connect to Confluence Cloud page with web connector

I am trying to gather table information on a Confluence page that I want in Power BI to analyse.

From Power BI, I choose Get Data > Web > paste the Confluence URL, enter the Confluence credentials as basic but then this error shows;

Unable to Connect

We encountered an error while trying to connect.

Details: "The credentials provided cannot be used for the web source....

Is it possible to connect to Confluence Cloud using Power BI Web connector?  There does not seem to be any connectors for Confluence Cloud to Power BI in marketplace.

 

1 answer

1 accepted

0 votes
Answer accepted

Hello Paul,

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!

Regards,
Stephen Sifers

Thanks Stephen, that is a brilliant idea.  We are away now until the 14th Jan.  So will add this to the plan then and let you know.  That's why they pay you the big bucks!  All the best for 2019.

Like Stephen Sifers likes this

Did you ever get this working?  If so can you update us please

No - I have not managed to get this to work

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

Introducing Confluence Cloud for Microsoft Teams (Available for Preview!)

Hi Atlassian Community, Remote work has shifted how teams collaborate, and we’ve heard from many of you that Microsoft Teams has become mission critical to many of your workflows, from how you chat...

2,411 views 16 19
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you