Connect power BI desktop to Power Bi server

[BartKemp1981]

Hi all,

I have most likely a rather simple question:

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,

Appreciate any help!

Kind regards

Bart

[Greg_Deckler]

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.

[BartKemp1981]

tnx for your help! helps a lot

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

[Anonymous]

If you are using on-prem data source, Yes you can schedule the refresh in PowerBI service under the gateway instead of live connection. Make sure the data source is supported by Enterprise Gateway. you can check it out here https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem