topic Re: How to access Power BI Rest APIs through Talend using basic authentication? in Talend Studio

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

Learner13 — Thu, 08 Jul 2021 14:56:53 GMT

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.

gjeremy1617088143 — Thu, 08 Jul 2021 15:19:26 GMT

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 — Thu, 08 Jul 2021 15:45:11 GMT

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 — Thu, 08 Jul 2021 15:45:47 GMT

I think this link will really help you :

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

on talend with rest component