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.

All responses (4)

Answers (1)

Davis-Z 5 on at

Like (1)

Report

Re: PowerBi REST API calls via HTTP conector

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'?
Verified answer

Kuby72 11 on at

Like (0)

Report

Re: PowerBi REST API calls via HTTP conector

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.
MJain 2,450 on at

Like (0)

Report

Re: PowerBi REST API calls via HTTP conector

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
Kuby72 11 on at

Like (0)

Report

Re: PowerBi REST API calls via HTTP conector

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()]])),