So my company is using a Microsoft NAV erp (sql based system). I am responsible for carrying out analysis; mainly in excel.
I currently use power pivot models and DAX queries to aggregate and explore my data further.
However I would like my models to link automatically to the table data in sql so that my models update automatically when the sql database is updated.
My questions are as follows?
How do I link a NAV table to powerpivot
Do I have to load all the tables from sql into powerpivot or can I create a connections?
How do I link the models to the sql tables so that the update automatically? I've heard something about using Sharepoint