Publish to local server from desktop

• SQL Espo

  SSCrazy

  Points: 2678

  More actions

  July 10, 2019 at 2:45 pm

  #3661604

  I am sure this answer exists, but I have spent a lot of time trying to figure it out and cant seem to find it.

   

  I have the free version of Power BI Desktop designer and want to publish to a local version of Power BI server. On the "Publish" button, I only see the web destination. Is there a way to add my local server as a publishing destination?

   

  I have attached my "destinations" list when I click Publish...

  Thank you so much in advance!

  Attachments:

  You must be logged in to view attached files.

• frederico_fonseca

  SSCoach

  Points: 16154

  More actions

  July 10, 2019 at 4:56 pm

  #3661658

  to publish to a Local  Server you need to use Power Bi Report Server https://powerbi.microsoft.com/en-us/report-server/

  Note that this is a licensed piece of software which you can use if you have either of the following

  • SQL Server enterprise with SA
  • Power BI Premium (Cloud based - subscription of 5k a month minimum)

    • Allows On Prem install of up to a certain number of cores according to the cloud subscription level

  • Or SQL Server Developer - for non production use

  In the case of local server you also need to use a specialized version of Power Bi Desktop which is at the same level of the Power BI Server

  see https://powerbi.microsoft.com/en-us/report-server/

  and https://www.microsoft.com/en-us/download/details.aspx?id=56722 for download