I want to use PI Desktop to consolidate several navision 2015 systems. As far as i understand the connection allowes me to refresh the data to desktop at my desire (set a schedule for example, or "get data" myself during the evening hours.
Once i have consolidated the data set in desktop, do I understand correctly I can push this data-set then to Power BI server? So the other users (we are a small company, only 3 users atm of Power BI) can use this data set for there reports?
Or would you recommend setting up the data in power BI server directly? (currently the data is "on premise" on our own servers in navision 2015. My IT depertment is concernd the "live" connection would be to much for our servers to use,
Yes, you would use Desktop to model your system and then publish to Power BI Report Server or Power BI Service and setup scheduled refresh. If you use the Service you will need a Data Gateway to access your on-premises data.
one more clarifying question if you would be so kind
I want to use desktop to pull data from Navision 2015. Can I do that also by scheduling a refresh in the evening for example? (Rather then using the standard live connection?) I want to limit the impact on our servers