PBI Data send through HTTP to be filled into Word Template

[WonderfulK]

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

[v-karpurapud · Accepted solution]

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.
 

[v-karpurapud]

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.

[WonderfulK · Accepted solution]

Yes i think i got my answer much appreciated

[v-karpurapud · Accepted solution]

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.
 

[lbendlin]

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