Forum Discussion
Solved
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 ...
If you're using SSMS, you should be able to generate a diagram of the table relationships
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