cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Connect power BI desktop to Power Bi server

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

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: Connect power BI desktop to Power Bi server

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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
New Member

Re: Connect power BI desktop to Power Bi server

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

 

Highlighted
Resolver III
Resolver III

Re: Connect power BI desktop to Power Bi server

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.