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
    3,748 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,716 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard