Export To File for Power BI Reports - ReportLevelFilters Filter not working

(0) Share

Report

Posted on by hejszyszki

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @hejszyszki

What's the filter you put in your ReportLevelFilters property?

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
hejszyszki 24 on at

Like (0)

Report

Was this reply helpful? Yes No
hejszyszki 24 on at

Like (0)

Report

Hi @v-yueyun-msft! Thanks for your reply.
Maybe i will input whole flow to understand the logic fully:

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi , @hejszyszki

According to your screenshot , your ReportLevelFilters code seems has no error. And i test it in my side ,it can works good:

TableName/ColumnName eq 'value'

You can try to use your run flow history's filter to test it in your Power BI side.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
hejszyszki 24 on at

Like (0)

Report

Thanks for your reply @v-yueyun-msft
The filter works fine - my bad i confused the posts.

The problem i am having is that Send an email (V2) does not attach the files at all.

What i did before is that I had a Send an email action within Apply to each loop, but in this case i was receiving multiple emails and got a request to turn it into all attachements within one email. (.pptx powerbi reports are attached files)

Based on the flow above i am receiving empty emails (without attachement) any idea what could be a reason here?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi , @hejszyszki

Based on your screenshot , you use the array variable as the attachments. You can try to delete the [ and ] in your append to array variable action.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
hejszyszki 24 on at

Like (0)

Report

Thanks for your reply @v-yueyun-msft
Unfortunetly it does not resolve the problem, hence it tells me to enter a valid json without square brackets

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (1)

Report

Hi , @hejszyszki

You can try to add the "" in your Name property:

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
hejszyszki 24 on at

Like (1)

Report

Okay, for this case it was not parantheses. There was no comma between Name and ContentBytes. Tested and works flawlessly. Thanks for help with investigation @v-yueyun-msft

Was this reply helpful? Yes No