Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Learner13
Contributor
Contributor

How to access Power BI Rest APIs through Talend using basic authentication?

I am trying to access PowerBI dataset using the Rest API (GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId})

as mentioned in the document: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset

using my credentials(having admin access) but I am not able to fetch it.

I am getting 403 forbidden error.

Please help.

Labels (3)
3 Replies
gjeremy1617088143
Master
Master

Hi, are you using a dataset id for the {datasetId} ?

Does it work if you call it via Postman for example?

maybe you have to generate a token first.

 Did you regsiter an app ?

https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app?tabs=customers%2CAzure

Send me Love and Kudos

Learner13
Contributor
Contributor
Author

I have put {datasetId}.

datasetId that appears in the URL while selection in PBI.

 

Where do we get the organisation name from?

PS: I don't know much about Power BI.

gjeremy1617088143
Master
Master

I think this link will really help you :

https://www.programmersought.com/article/85715023710/

then try your api call first via postman and if it's working you can transpose them

on talend with rest component