Answered

PowerBi REST API calls via HTTP conector

(0) Share

Report

Posted on by Kuby72

Hi,

I am doing flows using HTTP connector for calling Power BI REST API. I am succesfull with calls GET Datasets in Group, GET Groups, Get Refresh history in Group and I am able to load result into PowerApps. But calls GET Parameter in Groups neither Update Parameters in Group are always failing and I dont know why. I would appreciate any hint...

I always test everything on page https://docs.microsoft.com/en-us/rest/api/power-bi/ via Try IT and entering requested Id's manually and both calls are here successfull. Below you can see fail message and later setup and used parameters of HTTP call in Flow.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Kuby72 11 on at

Like (0)

Report
Copy link

Link copied!

I forgot to say, that same fails I have with both Calls in Power BI query
let
Source =
Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/groups/"&GroupID&"/datasets/"&DatasetID&"/parameters",
[Headers=[Authorization="Bearer "&GETAccessToken()]])),

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kuby72 ,

Are you sure you are using POST verb for updating the data. In the description you have mentioned GET . Can you please confirm.

Also since you are calling Power BI api I would suggest using "HTTP Request using Azure AD" you do need to create or get token first . It automatically takes care of it.

Thanks

Was this reply helpful? Yes No
Verified answer

Kuby72 11 on at

Like (0)

Report
Copy link

Link copied!

Hi ManishJain,
yes I am using POST, I shared not right printscreens... Today morning I recieved advice form my friend - link to Carl de Souza article https://carldesouza.com/how-to-authenticate-and-use-the-power-bi-api-inside-power-automate/ and I found out, that in my flow is missing client secret parameter. I added it into http call a nd it works now for all calls.

Was this reply helpful? Yes No
Davis-Z 5 on at

Like (1)

Report
Copy link

Link copied!

Hi, @Kuby72 and @ManishJain , in many cases, for security and privacy reasons, may I ask is there a way that we can avoid to hard code the credential within the http request? is there an another way instead of 'grant_type = password'?

Was this reply helpful? Yes No