Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
pamila-barros
New Member

Error token Power BI server with Power Automate

Hey guys.

 

I have a report developed on the power bi server, where I put the power automate button to export the selected data. With that, I published the report, it turns out that in the link (online) the automation does not work and in the BI Server program on the machine it works.
When looking deeper I noticed that it is giving an error in the Reques URL in the creation of the Flow token.
The automation itself is working perfectly, only after the report sent to the online server did not work. Please if anyone has gone through something like that, let me know.

 

pamilabarros_0-1632837851622.png

 

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @pamila-barros 

 

It sounds like you use powerbi service instead of powerbi report server? Report Server is on-premises. 

The error screenshot you provide is hard to judge.

Please follow the tutorial to create powerbi automate button:

Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Docs

There are known limitations:

  • The user running the flow within the Power BI report needs to have permissions to run the flow. Grant these permissions through direct sharing by the user or by sharing to an Azure Active Directory group.
  • The Power BI visual only functions with flows in a tenant's default environment. Any flow created with the visual is created in the users default environment.
  • Additional manual inputs to the button are not supported at this time.
  • The visual is not supported for PaaS embedded scenarios nor in Sovereign Cloud scenarios.
  • Create flows that you will use with the Power BI button trigger directly within the Power BI report. Do not go directly to Power Automate to create these flows as the trigger will not have access to the data fields necessary for creating the flow.
  • Power BI data will be sent to and processed in a geography where the flow is deployed.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

 

View solution in original post

6 REPLIES 6
pamila-barros
New Member

Hi @v-janeyg-msft 
Yes, we are talking about the same subject.
Thanks for your answer!

v-janeyg-msft
Community Support
Community Support

Hi, @pamila-barros 

 

It sounds like you use powerbi service instead of powerbi report server? Report Server is on-premises. 

The error screenshot you provide is hard to judge.

Please follow the tutorial to create powerbi automate button:

Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Docs

There are known limitations:

  • The user running the flow within the Power BI report needs to have permissions to run the flow. Grant these permissions through direct sharing by the user or by sharing to an Azure Active Directory group.
  • The Power BI visual only functions with flows in a tenant's default environment. Any flow created with the visual is created in the users default environment.
  • Additional manual inputs to the button are not supported at this time.
  • The visual is not supported for PaaS embedded scenarios nor in Sovereign Cloud scenarios.
  • Create flows that you will use with the Power BI button trigger directly within the Power BI report. Do not go directly to Power Automate to create these flows as the trigger will not have access to the data fields necessary for creating the flow.
  • Power BI data will be sent to and processed in a geography where the flow is deployed.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

 

Hello good Morning.

Yes, we use the Report Server, that print is inside the reporter server website by clicking on the F12 key to view.
Returning to the issue of the report, the power automate button was created within BI. Execution by the automate is not done on the server by default of token creation. The question is, if I make a report inside the power bi server, with an automate button, saving the report on the power bi server (publishing to online folders), it doesn't run the automation. Why?

@pamila-barros  I didn't see the power automate button visual on the January version of RS deskop. What version are you using?

July

Hi, @pamila-barros 

 

AFAIK, PowerBI RS desktop doesn't support this visual, this visual can only be used in powerbi deskop.

This visual won't appear on the visual page of RS desktop and it is not supported even if it is added.

Like this:

vjaneygmsft_0-1633683009930.png

So, Are we talking about the same thing?

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.