Paginated Report: Excel Output as Tables

[abpgupta]

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!

[setis]

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]

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.

[AbhiSSRS · Accepted solution]

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 :

[Anonymous]

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?

[uyarasi]

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

Thanks,

UY

[abpgupta]

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

[uyarasi]

Do you have a screenshot or sample that you can share?

Thanks,

UY

[abpgupta]

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.

[GoAvs]

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.

[mohammedadnant]

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

[Anonymous]

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]

@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.