Forum Discussion

Jdrien's avatar
Jdrien
Frequent Visitor
2 years ago
Solved

Apply filters on REST API JSON POST request

hello, ​​​​​​​I'm trying to call the powerBI REST api (JSON) i can get the page i want and creat the pdf, but i cant' manage to apply filters, I've created a really simple page for tests (just a s...
"And filter"
"Need Help"
"Power BI Report Server Printing"
  • Jdrien's avatar
    Jdrien
    2 years ago

    Ok i've figured why i had this problem, my segment was set to "one selection" so there was always an item selected, the problem was the api downloaded the report with this selcection, then tried to filter it. i just had to uncheck "only one selection", uncheck everything, save the report, then i could filter my report!
     

fabyx's avatar
fabyx
Frequent Visitor
1 year ago
Hello, nice people. I have been reading this post, and it seems to look like the one that is related to the problem I am facing now. I have been trying to export a PowerBI report to a PNG image, but when I apply a filter before exporting it does not work,
 
my body looks like this.
const body = {
format: "PNG",
powerBIReportConfiguration: {
formatSettings: { OutputFormat: "PNG" },
settings: {
locale: "en_US",
},
pages: [
{
pageName: "ReportSection1",
},
],
reportLevelFilters: [
{
target: {
table: "test1group and company",
column: "company",
},
operator: "eq",
values: ["5"],
filterType: 1,
},
],

 

//reportLevelFilters: ["test1group and company/company eq '5'"], // i also used this way 

//filter: ["test1group and company/company eq '5'"], // i also used this way 

identities: [
{
username: "email",
roles: ["S"],
datasets: ["datasetId"],
},
],
},
};
 
i tried so many options but my filter is not working at all. if anyone has an idea of how i can work around this issue kindly help,
 
when i checked on the link above i saw filter receives a string as for the example below

i tried to stringfy the object but still get the same issue and passing  something like  this "test1group and company/company eq '5'"

 

if anyone can help i will be appreciative it 

 

thanks

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

You need to escape spaces in table and column names

  • fabyx's avatar
    fabyx
    Frequent Visitor
    1 year ago

    Hallo lbendlin 

    thank you for getting back to me,

     

    I have different scenarios

     

    1st scenario.

    reportLevelFilters: [
    {
    $schema: "http://powerbi.com/product/schema#basic",
    target: {
    table: "test1group%20and%20company",
    column: "company",
    },
    filterType: 1,
    operator: "eq",
    values: ["5"],
    requireSingleSelection: false,
    },
    ],
     
    i get this kind of error 

     

    Power BI Export Error: {
    code: 'InvalidRequest',
    message: 'Export report filter with empty string provided'
    }

     

    2nd scenario is when i use paramaters

     

    reportLevelFilters: [
    { filter: "test1group%20and%20company%2Fcompany%20eq%20'5'" },
    ],

     

    this doesn't show an error, the image is exported but without filter applied 

    3rd scenario

     reportLevelFilters: [
    {
    filter: {
    $schema: "http://powerbi.com/product/schema#basic",
    target: {
    table: "test1group%20and%20company",
    column: "company",
    },
    filterType: 1,
    operator: "eq",
    values: ["5"],
    requireSingleSelection: false,
    },
    },
    ],

    when i add filter the response change to this

     

    Power BI Export Error: {
    code: 'BadRequest',
    message: 'Bad Request',
    details: [
    {
    message: 'Invalid value',
    target: 'request.powerBIReportConfiguration.reportLevelFilters[0].filter'
    },
    { message: "'request' is a required parameter", target: 'request' }
    ]
    } 

     

    i am really stuck on this topic, every resources that i can find is suggesting the same thing

     

    i followed this table for escaping the all required characters

    if you have ever got this before or anyone here was in the same situation as mine, kindly help out 

     

    thanks 

    Faby