Forum Discussion
Monitor ERP
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.
If you're using SSMS, you should be able to generate a diagram of the table relationships
4 Replies
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/294447Hope this helps!!
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.
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.
If you're using SSMS, you should be able to generate a diagram of the table relationships
