Excel report export, format as table.
I am exporting a report on site collection size, I would like to know if there is a way to format the report as a table, so that I can import into PowerBI?, currently I have to open each report and format as table, so I can then import into PowerBI
2
votes
Kaine
shared this idea
-
Kaine
commented
To be able to use the excel exports in PowerBI, they need to be formatted as a table, it would be great if this could be done as part of the export / report, so that the scheduled tasks can save the Excel report in a table format and PowerBI can read that without having to edit each report.
-
rarroyo
commented
I would like to automate something with PowerApp and Power Automate but they require the data to be formatted as a table.