Forum Discussion
Converting Current REporting EXCEL to BI
Good day,
I have been using Excel to generate my Reporting on a daily basis and to keep count of record and Staff work.
I want to convert this file to Power Bi.
Anyone can help me to do so or to teach me how to do so?/
Hi,
To start with, open PowerBI desktop and go to Home > Get Data > Excel and import the individual Tables. Then create relatiosnhips between Tables. Write measures, if required and start building your visuals.
Hi mahendaran,
If your Excel file contains Power Pivot models or Power View worksheets, you can directly import Excel Workbook content into desktop.
Regards,
Yuliana Gu
2 Replies
- Ashish_Mathur
Super User
Hi,
To start with, open PowerBI desktop and go to Home > Get Data > Excel and import the individual Tables. Then create relatiosnhips between Tables. Write measures, if required and start building your visuals.
v-yulgu-msftMicrosoft Employee
Hi mahendaran,
If your Excel file contains Power Pivot models or Power View worksheets, you can directly import Excel Workbook content into desktop.
Regards,
Yuliana Gu