connecting power bi to focal point by API

[Anonymous]

I am trying to connect power bi to focal point but dont even know where to start with get data. I have tried ODBC and the WEB for my get data, but its failing everytime. information ive been given is.

• Username: ODBC_WRC
• Password: <as advised>
• Server: 10.48.35.68
• Driver: “SQL Server Native Client 11.0”
• Database: WRc

can anyone help me. thanks

[v-xulin-mstf]

Hi @Anonymous,

Coud you provide more details about 'focal point'?

About how to Use a REST API as a data source, please refer:

https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[PhilipTreacy]

Hi @Anonymous 

When you say you are trying to 'connect to Focal Point' do you mean a database inside your organisation developed by Focal Point?

Given the info you have provided, have you tried using the SQL Server connector in Power BI?

Regards

Phil