If you want to import Analytics data manually through Power BI, follow these instructions.
In Power BI, click Get Data in the lower left screen.
Under Import or Connect to Data > Files, click Get.
Click Local File.
Choose which file to upload and click Open.
Click Upload under Upload your Excel file to Power BI.
The message “Your file has been uploaded” should appear.