ReportLevelFilters Filter in Export to File for Power BI Reports

(0) Share

Report

Posted on by gstredny

134

I am having trouble getting this to work for me and I can't find any literature on how to filter a Power BI report by a specific variable and filter in your report. I can get the Export to File for Power BI Report to export my report page, but it is unfiltered.
My trigger will be from when an item is created or modified from a sharepoint list. I just want it to filter by one column in one table of my powerbi report. So for example my table name is Lab Analysis and my column name is assetname.

[
  {
    "filter": "?filter=ANALYTICS LabAnalysis_sv (Pivoted)/assetname in ('AssetName')"
  }
]

this doesn't filter anything.

I also tried this as well: ANALYTICS LabAnalysis_sv (Pivoted)/assetname in ('assetname') and that did not work.

Any tips would be great!

I also tried this and it did not work. The name of my filter and hardcoded a value in there:

[

{

"filter": "?filter=ANALYTICS LabAnalysis_sv (Pivoted)/assetname in ('AssetName')"

}

]

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Is ANALYTICS LabAnalysis_sv (Pivoted) the table name?

I believe the issue is with you query syntax.

See this post and this documentation

If you still need help, please let me know.

Was this reply helpful? Yes No
gstredny 134 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I have tried every combination of syntax and still can't get it to filter:

[

  {

    "filter": "'ANALYTICS LabAnalysis_sv (Pivoted)'/assetname eq 'Asset 1H'"

  }

]

My table is 'ANALYTICS LabAnalysis_sv (Pivoted)'

My column name is assetname

My value is Asset 1H

Now I can't even get the URL filter to work:

https://app.powerbi.com/groups/e71329a7-1fcf-4b65-b605-443d377331d2/reports/688f91d8-45d2-4a95-8f5d-b6d823107749/ReportSectionb122d800497891c3f34b?filter'ANALYTICS LabAnalysis_sv (Pivoted)'/assetname eq 'Asset 1H'

Was this reply helpful? Yes No
Suggested answer

gstredny 134 on at

Like (1)

Report
Copy link

Link copied!

I figured it out! It was something with the table name PowerBI didn't like I changed tables and this works:

[

  {

    "filter": "ANALYTICS_Asset_sv/Asset eq 'Asset 1H'"

  }

]

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

See my other post

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

I'm glad that you got it working! I was also experimenting and found that it appears as though you can use _x0020_ in place of the spaces in the table name.

See this post in one of the Power BI forums for further explanation.

Was this reply helpful? Yes No
gstredny 134 on at

Like (0)

Report
Copy link

Link copied!

O ok great I will try adding that for spaces!

Was this reply helpful? Yes No
LB-04112000-0 50 on at

Like (1)

Report
Copy link

Link copied!

Please follow the documentation. Avoid special characters or escape them as described.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters

Was this reply helpful? Yes No
NS-07040731-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I have the same issue

I would like to know if the filter works if the field is in a linked table ?

Thank in advance

Was this reply helpful? Yes No
Suggested answer

RS-28072001-0 2 on at

Like (0)

Report
Copy link

Link copied!

I had this issue. Try doing all lower case. Worked for me.

Was this reply helpful? Yes No