Export pdf from powerbi to sharepoint via powerautomate

[hodeuria]

I need help to export files in pdf format from power bi to sharepoint via power automate. 

I’ve created an automated flow that runs successfully, but it doesn’t apply filters based on a single column. My goal is to filter the report for each business individually, as if using the Power BI filter pane. I want to be able to export automatically business by business automatically using the filter pane. 

Thanks

[tayloramy]

Hi @hodeuria, 

Another thing you could try is using the HTTP connector and using the power bi export API.  

Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

you can then build a filter string to filter the report: 
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[v-menakakota]

Hi @hodeuria ,

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @Zanqueta  and @rohit1991   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the aboce details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team

[v-menakakota]

Hi @hodeuria  ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team

[Zanqueta · Accepted solution]

Hi @hodeuria,

I'm not sure if you're using the step 'Run a query against a dataset'. If you are, you need to apply a filter in your test query, as shown in the image below.

I recommend reed the posts.

Re: Power Automate - "Run a query against a datase... - Microsoft Fabric Community

Power Automate Run A Query Against A Power BI Dataset

Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Po...

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

[hodeuria]

Hi, thank you for this. This has actually helped with the dynamic filtering! 

[v-menakakota]

Hi @hodeuria ,

Thank you for the update, 

[rohit1991]

Hii @hodeuria 

Follow the below steps to get your result :

1. Get the list of all business names (from Excel, SharePoint, SQL, etc.).
2. Use Apply to Each so the flow runs once per business.
3. Inside the loop, pass the filter as JSON into the Export to File for Power BI Reports action.

Example filter JSON
[
  {
    "table": "BusinessTable",
    "column": "BusinessName",
    "operator": "In",
    "values": ["Business A"]
  }
]

Each loop run replaces "Business A" with the next business, and Power BI returns a correctly filtered PDF.