Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to export a table with calculated measures to excel automatically each day

Hello,

I have a table created with calculated measures from different data sources into my report, and i want to exctract that table, preferably in a tabular form (for an LLM to read), in order to add that exported data into a daily flow. I dont want the underlying data, I want what the table shows as is.

 

Thank you all in advance!

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    I think you can try to export data from power bi visual by power automate.

    You can refer to this solved post with similar issue like yours, I hope it could help you solve your issue.

    For reference:
    Solved: export data from power bi visuals to excel automat... - Microsoft Fabric Community

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous Place your columns and data into a Table visual, hover over the visual, click the ellipses (...) and choose Export data.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Greg_Deckler Hi Greg, thanks for your reply. The thing is that i need for that table to get exported automatically, without touching a thing, in order for the flow to get the latest table data and get executed with the refreshed one.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous ,

         

        I think you can try to export data from power bi visual by power automate.

        You can refer to this solved post with similar issue like yours, I hope it could help you solve your issue.

        For reference:
        Solved: export data from power bi visuals to excel automat... - Microsoft Fabric Community

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.