cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kuby72
New Member

PowerBi REST API calls via HTTP conector

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. Failmessage.pngFlowSetupGETparameters.pngFlowSetupUpdateparameters.png

1 ACCEPTED SOLUTION

Accepted Solutions

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.

PostPBIToken_a.pngPostPBIToken_b.png

View solution in original post

3 REPLIES 3
Kuby72
New Member

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

ManishJain
Solution Sage
Solution Sage

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

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.

PostPBIToken_a.pngPostPBIToken_b.png

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (4,513)