Data pre requisition for the dashboard --table format official document

[Anonymous]

Hi,

could anyone provide a link of an official document of the requirements of PowerBI need flat table format data as input?

currently need to help the financial department change excel reports to powerBi dashboards/reports

input data excels are all pivotal tables and when adding data, it is always adding columns but not rows.

it is really hard to convince the colleagues we need to reformate the data in excel to flat data format, so hope to find the official document presenting to them saying, the pivotal table will not work. 

thank you! 

[Anonymous · Accepted solution]

Hi @Anonymous ,

I'm not quite sure what you're asking, but hope on of these docs will help:

https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-connect-to-data

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-analyzing-sales-data-from-excel-and-an-odata-feed

https://docs.microsoft.com/en-us/power-bi/service-get-data-from-files

https://docs.microsoft.com/en-us/power-bi/service-from-excel-to-stunning-report

https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

- Michele

[Anonymous]

Thank you so much for the info