web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate – Expor...
Power Automate
Unanswered

Power Automate – Export Power BI en PDF avec filtre

(1) ShareShare
ReportReport
Posted on by 2

Sujet : Power Automate – Export Power BI en PDF échoue avec “Export report filter with empty string provided”

 

Bonjour,

J’ai un flow Power Automate avec l’action Power BI – Exporter vers un fichier pour les rapports Power BI (InitiateExportToFileForPbiReports).

Contexte

  • Format : PDF
  • Je veux filtrer le rapport sur :
    • Table : Synthèse_CC
    • Colonne : Profil
    • Valeur : CC

Erreur

L’action échoue avec :

  • StatusCode: 400
  • error.code: InvalidRequest
  • error.message: Export report filter with empty string provided

Payload utilisé (version JSON reportLevelFilters)

json
[
  {
    "$schema": "https://powerbi.com/product/schema#basic",
    "target": {
      "table": "Synthèse_CC",
      "column": "Profil"
    },
    "operator": "In",
    "values": ["CC"],
    "filterType": 1,
    "requireSingleSelection": true
  }
]

J’ai aussi testé une version simplifiée sans filterType ni requireSingleSelection, même erreur.

Point de confusion

Dans mon UI Power Automate, j’ai un champ Filter (et pas toujours clairement reportLevelFilters).
Je ne sais pas si je dois envoyer :

json
[
  { "filter": "Synthèse_CC/Profil in ('CC')" }
]

Questions

  1. Quel est le format exact attendu par l’action Exporter vers un fichier selon ce champ Filter ?

  2. Y a-t-il une différence de syntaxe selon la version du connecteur Power BI ?

  3. Avez-vous un exemple fonctionnel minimal pour filtrer Profil = 'CC' sur export PDF ?

Merci d’avance pour votre aide.


     
 
Capture d’écran 2...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)
  • Vish WR Profile Picture
    1,725 on at
    Hi
     
    Can you try this and see if it works?
    [
    {
    "$schema": "http://powerbi.com/product/schema#basic",
    "target": {
    "table": "Synthèse_CC",
    "column": "Profil"
    },
    "operator": "In",
    "values": ["CC"],
    "filterType": 1
    }
    ]
     
     
     
      Vishnu WR
     
    Please  Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like 
     
     
     
  • lbendlin Profile Picture
    8,690 Super User 2026 Season 1 on at
    Your table name has special characters. You need to encode these. 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 641

#2
Vish WR Profile Picture

Vish WR 640

#3
Haque Profile Picture

Haque 495

Last 30 days Overall leaderboard