Need help with PowerBI report export via Power Automate

[ChrisAZ]

So I have posted previously on this, but thought a video of my steps could be useful. I feel like it has to be something silly and small at this point keeping me from getting the correct email output that is individualized.

Problem explanation video 

[tayloramy]

Glad I could help. 

If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution. 

[tayloramy]

@ChrisAZ, 

Glad to hear it. 
Now let's adjust it in Power Automate. 

Back on this screen: 

change the filter to 

Portal_x0020_Revenue/Driver_x0020_Name eq 'Andrew Parker'

replacing Andrew Parker with the output from your excel sheet. 

If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution. 

[ChrisAZ]

So I changed it to this below, but the emails are still set to All Drivers and not filtering:

[tayloramy]

@ChrisAZ 

Please remove the quotes around the table name now. The only quotes should be around the output from the excel file.
Also remove the space. 

The Table/Column section of the filter should be exactly this: 

Portal_x0020_Revenue/Driver_x0020_Name

[ChrisAZ]

Tried running this and still no filters:

[tayloramy · Accepted solution]

You still have a space in the table name after the word Portal. 
Please remove the space and try again. 

[ChrisAZ]

It works. You are a life saver. Thank you so much!

[tayloramy]

@ChrisAZ 

Try adding this filter at the end of the report URL: 

&filter=Portal_x0020_Revenue/Driver_x0020_Name eq 'Andrew Parker'

 If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution. 

[ChrisAZ]

That works! So now what do I change in my Power Automate?

[ChrisAZ]

So I tried adding it now before and after those as well but it did not change the results at all. Curious what is different about the workflow you created and how it works.

[tayloramy]

Interesting. 

This is my workflow: 

This is a simpler example as I am not dynamically getting the filter condition or email list, but it demonstrates the functionality of the power bi export itself. 

Can you try building a URL to filter the report? 
Something like: 
https://app.powerbi.com/groups/ ... ?experience=power-bi&filter='Portal Revenue'/'Driver Name' eq 'Andrew Parker'

and see if you cna get the filter to work in the web? This will help rule out of the filter is wrong or if there's an issue on the Power Automate side of things

[ChrisAZ]

Thanks for sticking with me on this. Do you know where/how I would determine the full URL? Sorry, I am quite new to Power Automate.

[tayloramy]

Hi @ChrisAZ, 

The URL is the link to the Power BI report. 
Open up the report in your workspace, and then append the filter parameter to the end of the URL

&filter='Portal Revenue'/'Driver Name' eq 'Andrew Parker'

The general format for report URLs is: 

https://app.fabric.microsoft.com/groups/{Workspace ID}/reports/{Report ID}/{Report Page ID}

If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution. 

[ChrisAZ]

So I added &filter='Portal Revenue'/'Driver Name' eq 'Andrew Parker' to the end of that URL for that report and when it loaded (it changed the full URL some on its own), it still loaded the report for All Drivers and not for Andrew Parker.

[tayloramy]

@ChrisAZ 
Okay so this tells us that the filter condition is not working, so no matter what you do in Power Automate this isn't going to work until the filter condition is corrected. 

I recommend reviewing the documentation about query string parameter filtering: 
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

THe next thing I would try is encoding the spaces: 

&filter=Portal_x0020_Revenue/Driver_x0020_Name eq 'Andrew Parker'

Can you also send a screenshot of the semantic model so I can see what the table and column look like in there? 

If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution.  

[ChrisAZ]

By encoding the spaces, meaning add the space in before the name?

[tayloramy]

Hi @ChrisAZ, 
I just made a mock sample of this in my environment, and the filter is working as expected. 

Have you tried hard coding one of the driver names yet?

Actualy, upon closer looking, it seems that your table name has a space in it but is not sorrounded by quotes, that might be what is causing the filter to fail. 

Can you correct that and try? 

If that doesn't work, I suggest to try hard coding a specific driver name to see if the error is on the Power BI connector or if it's in reading the data from excel. 

If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution. 

[ChrisAZ]

Thanks for the response! Are you referring to here?

If so, I just added that, and reran it but same issue where it is just running it for "All Drivers" instead of feeding the names. It also shows in the Log the following which would imply it is feeding the names:

Then it has the second driver's name from the list as well. When it gets to me via email it only shows those names in terms of sending one out to that driver name, but not applying it correctly filtered in the attachment.

[tayloramy]

Hi @ChrisAZ, 

I'm referring to here:  

It should say 'Portal Revenue'/'Driver Name' eq 'blah blah blah' 
the ' before Driver and after Name is missing I believe.