This article explains how to migrate a Power Query or Power BI report from m3livedata.kemin.com to m3data.kemin.com. 


If you want to know more about near real time data reporting please visit the following link https://keminind.sharepoint.com/sites/ServiceCatalog/SitePages/Data-management-and-reporting-architecture-training-for-M3-users.aspx


  • In Excel, go to Data->Get Data->Launch Power Query Editor


Open Power Query Editor


  • From the main menu, select Data source settings (1), then  select the connection to m3livedata (2) and finally click on Change source (3)


Open the change source panel


  • Enter following connection details: 


Please note these parameters are valid to access th M3 TRN environment and will change when connecting to the PRD environment


  • Click Ok 

  • Verify the changes were saved, then close the panel


Depending on the configuration of your query, you might need to complete following additional steps.


  • Select your query from the left panel (1)
  • go to the Navigation step (2)
  • click on the gear icon to modify the step and select the view used in the report 



  • select the appropriate view and click Ok to close

  • Go to Home->Refresh Preview->Refresh All to 

  • After the refresh is complete, you might need to adjust the filters to ensure the report is compatible with the new company structure or example
  • Click on Close & Load to load the results to Excel.