Forum Discussion

ChrisAZ's avatar
ChrisAZ
Icon for Helper V rankHelper V
1 year ago
Solved

Need help with PowerBI report export via Power Automate

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...
Need Help
  • tayloramy's avatar
    tayloramy
    1 year ago

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

ChrisAZ's avatar
ChrisAZ
Icon for Helper V rankHelper V
1 year ago

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's avatar
tayloramy
Icon for Super User rankSuper User
1 year ago

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's avatar
    ChrisAZ
    Icon for Helper V rankHelper V
    1 year ago

    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's avatar
      tayloramy
      Icon for Super User rankSuper User
      1 year ago

      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's avatar
        ChrisAZ
        Icon for Helper V rankHelper V
        1 year ago

        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.