topic Re: PBI Data send through HTTP to be filled into Word Template in Developer

PBI Data send through HTTP to be filled into Word Template

WonderfulK — Mon, 04 May 2026 20:43:11 GMT

I am working on a project.

I have built a dashboard with data that need to be uploaded into a word templatw. Idea is like this , filter the data use quick measures to create json lists , import HTML Visual and feed variables that will contain these json dax queries. These are supposed to be sent to a flow in a power automate.

But whenever i try i get 400 auth error and the http url in the trigger "When an HTTP request is made" outputs end point url and not product url.

Is this doable if yes i would appreciate your help.

Thanks

Re: PBI Data send through HTTP to be filled into Word Template

lbendlin — Tue, 05 May 2026 13:28:08 GMT

Have you considered using the Power Automate visual instead of the HTML visual?

Re: PBI Data send through HTTP to be filled into Word Template

v-karpurapud — Fri, 08 May 2026 11:17:04 GMT

Hi @WonderfulK
Thank you for contacting the Microsoft Fabric community forum.

The issue is not related to the DAX or JSON logic, but to platform limitations with Power BI custom visuals. HTML visuals run in a sandboxed and security-restricted environment, which makes direct authenticated HTTP POST requests to Power Automate HTTP triggers unreliable and unsupported.

Although the Power Automate HTTP trigger URL contains authentication parameters, browser security restrictions and Power BI’s controlled authentication model can prevent the required headers or signatures from being passed correctly, resulting in HTTP 400/authentication-related errors.

As recommended by @lbendlin , use the native Power Automate visual within Power BI instead of the HTML visual with an HTTP trigger. This is the supported integration method and automatically handles authentication and report filter context for scenarios such as generating Word documents from Power BI data

Here are some references:
The authentication API in Power BI custom visuals - Power BI | Microsoft Learn
Create a Power Automate visual for Power BI - Power BI | Microsoft Learn

If you have any further questions, feel free to reach out and we'll be glad to assist.

Regards,

Microsoft Fabric Community Support Team.

Re: PBI Data send through HTTP to be filled into Word Template

v-karpurapud — Mon, 11 May 2026 12:42:03 GMT

Hi @WonderfulK

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

Re: PBI Data send through HTTP to be filled into Word Template

WonderfulK — Mon, 11 May 2026 20:10:48 GMT

Yes i think i got my answer much appreciated