Forum Discussion

abpgupta's avatar
abpgupta
Continued Contributor
5 years ago
Solved

Paginated Report: Excel Output as Tables

Hi All

 

I noticed when we download Excel output from Paginated report, it doesn't create Excel tables for outputs. Because of this, when we use it in Power Automate to read, we have to add additional steps to convert to table to read and extract information and run into other issues.

 

When we download excel from Power BI Desktop, output excel have table name by default and can be used.

 

Is it some specific settings or type which can enable Excel output to have table name for Paginated reports as well? 

 

Thanks for inputs!

 

 

Need Help
Tips and Tricks
  • AbhiSSRS's avatar
    AbhiSSRS
    5 years ago

    Please create a pixel aligned table in paginated with loaction 0,0 and column width in round numbers or 1 decimal only eg 1,1.5,2in . Also please do not merge any headers in groups that you create. This would help create a valid table output. Click Advanced mode in groups to verify your settings as below :

     

12 Replies

  • AbhiSSRS's avatar
    AbhiSSRS
    Solution Sage
    5 years ago

    Please create a pixel aligned table in paginated with loaction 0,0 and column width in round numbers or 1 decimal only eg 1,1.5,2in . Also please do not merge any headers in groups that you create. This would help create a valid table output. Click Advanced mode in groups to verify your settings as below :

     

    • abpgupta's avatar
      abpgupta
      Continued Contributor
      5 years ago

      Thanks AbhiSSRS  for information! I will try this and see it works.

       

      As of now, I used Create Table function in Power Automate with removing blanks to  assign a table name to it for further processing.

       

       

    • uyarasi's avatar
      uyarasi
      Frequent Visitor
      4 years ago

      Hi @AbhiSSRS , do you have a sample report? I tried several times and not able to export the report to table.

       

      Thanks,

      UY

      • abpgupta's avatar
        abpgupta
        Continued Contributor
        4 years ago

        It doesn't work at my end as well. I am using Power automate Functions to convert to table. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi i have created 1 table and 2 matrix for our users internal analysis of purchase order data. but when i m exporting to excel columns are merging can you help me formating those tables?

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi abpgupta ,

     

    I did a test. If I understood it correctly, do you mean to have a clear table without any formatting?

     

     

    Best Regards,

    Yuna

     

     

    • abpgupta's avatar
      abpgupta
      Continued Contributor
      5 years ago

      Anonymous , I meant to format as Table so that Power automate can recognize various tables created in Paginated report and can be used further to extract data. 
      in desktop report export data does it; however, we have to download one by one manually. I think Paginated Report can provide automated way to extract excel outputs for multiple tables in a report and send custom data alerts. 

       

       

  • mohammedadnant's avatar
    mohammedadnant
    Impactful Individual
    5 years ago

    Hi abpgupta 

     

    Paginated report will export the table exactly to each cell in the excel.

    it will happen only when you design the report correctly.

    for an example: if you design the report like this below image,

    the 1st column will split into 2 due to the title of the report, 

    try to place the objects in place to export exact result in the excel.

     

     

    Thanks & Regards,

    Mohammed Adnan

    Learn Power Platform for free: https://www.youtube.com/c/taik18

  • GoAvs's avatar
    GoAvs
    Frequent Visitor
    5 years ago

    Same question.  Would like to use results in a Flow to include text like "report returned X value" in the flow-generated email. As I understand Flow can only import cells/rows from Excel Named Tables.

  • setis's avatar
    setis
    Post Partisan
    5 years ago

    I have exactly the same question and I can figure out how to export as an exel table to be able to use it from Power automate. 
    I get the data exported but without the proper table formatting. abpgupta did you figure it out?

    • abpgupta's avatar
      abpgupta
      Continued Contributor
      5 years ago

      Yes, in Paginated Report, I created a dummy column with value as 'ALL' for export. creating it at (0,0) position ensures there are no additional blank rows to deal/filter with.


      Then in Power Automate, used "create table" giving a suitable high range with custom table name.  

      Then used List value present in table with filter on dummy column (eq 'ALL') to exclude blank rows from table. 

      Now with this output , you can populate data to other steps.