Before accessing M3 data reporting you’ll need to make sure your account has been granted with necessary access rights. To do this you can proceed as follows:
Go to the IT service catalog following this link https://keminind.sharepoint.com/sites/ServiceCatalog
Click on Submit a Request
Then select the Access Request link
This will bring you to the Kemin IT Access request form
Enter your data in the upper section, then select the SSAS Data Access and PowerBI App Access (1) option from the Access Request Type menu and tick the M3 Live Data check box.
This will give you access to M3 live data database; you’ll use Power Query and Power BI to read data directly from the M3 database
In the lower section, you can select the data/tables which you want to have access to.
After you’ve select one of more options, click the Save button; this will trigger an automatic process and you’ll be notified via an help desk ticket when your account has been provisioned with necessary access rights.