Forum Discussion

BartKemp1981's avatar
BartKemp1981
New Member
8 years ago

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 dat...
Help me please
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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's avatar
BartKemp1981
New Member
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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