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
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…