cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abpgupta
Helper V
Helper V

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!

 

 

1 ACCEPTED SOLUTION
AbhiSSRS
Super User
Super User

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 :

AbhiSSRS_0-1617129476255.png

 

View solution in original post

10 REPLIES 10
setis
Post Partisan
Post Partisan

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?

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
Super User
Super User

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 :

AbhiSSRS_0-1617129476255.png

 

View solution in original post

uyarasi
Frequent Visitor

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

 

Thanks,

UY

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

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
Frequent Visitor

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
Responsive Resident
Responsive Resident

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.

mohammedadnant_1-1616756800389.png

 

 

Thanks & Regards,

Mohammed Adnan

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

v-yuaj-msft
Community Support
Community Support

Hi @abpgupta ,

 

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

v-yuaj-msft_1-1616746932544.png

v-yuaj-msft_2-1616746984342.png

 

 

Best Regards,

Yuna

 

 

@v-yuaj-msft , 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. 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors