Monitor ERP

[Bjarne_IQM]

Does anyone have experience with importing Monitor ERP data into Power BI? I'm struggling with this because there is no overview of the relationships between the different tables, and there are many fields where data needs to be retrieved from other tables, similar to CRM data.

[shafiz_p]

Hi @Bjarne_IQM 
Try reading this earlier solution on how to retrieve data from Monitor ERP:
https://community.fabric.microsoft.com/t5/Power-Query/Retrieve-data-from-ERP-Monitor/td-p/294447 

Hope this helps!!

[danextian]

If you're connecting to its SQL database, there is an option to include relationshipo columns in the query. It will not give you relationship overview but an idea of the columns it is related to. But doesn't the software provider have documentations avaiable? whoever the vendor that set it up must have the documentations.

[Bjarne_IQM]

Thank you very much for your response.

I have been trying for 2 months to obtain this documentation from the supplier, but they have not been able to provide me with this information. Therefore, I don't think they have it.

[danextian · Accepted solution]

If you're using SSMS, you should be able to generate a diagram of the table relationships