Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hosting PBI Desktop reports on Report Server

I just have some basic questions about this. If I publish a Power BI Desktop report to Report Server on premise, do I need a gateway for Azure Cloud data sources whether it is import or direct query or live connection? But a report using on premise data sources will be accessible if published to Report Server whether it is import or direct query or live connection, right?

 

Also, I have run into an issue where I have tried to upload a Desktop report to Report Server and I got the following message:

"We can't save this Power BI Desktop report because either it is newer version or has component parts that are not supported."

The version of Desktop I am using is the one which I downloaded using the link from the Report Server page, so it is the same version. I tried to test uploading a very basic report with just a table, using imported data from a SQL Server database. Any idea what the component part which is not supported could be?

Data Source Report Server
Gateways
Report Server

11 Replies

  • KBO's avatar
    KBO
    Memorable Member
    6 years ago

    Hi Anonymous ,

    1) you don't need any gateway in your own environment to set up a schedule refresh. 

    2) Make sure that the desktop version and the report server version are the same. That is important you can't use a newer desktop on a old report server.

     

     

    Best,

    Kathrin

     

     

     

     

    If this post has helped you, please give it a thumbs up!
    Did I answer your question? Mark my post as a solution!

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    1. for scheduled refresh of imported data source or directquery or live connection mode you need a gateway from RS to each of data sources

    2. make sure your RS version is up to date. also check if you have any non built-in visuals in your project

     

    • KBO's avatar
      KBO
      Memorable Member
      6 years ago

      Hi az38 , this is not cloud. You don't need a gateway if you are on premises and the sources are also in your environment. You only need the driver for the source systems. 😉

       

      Best,

      Kathrin

      • az38's avatar
        az38
        Community Champion
        6 years ago

        KBO 

        well, it's a question of definitions

        Driver is a kind of gateway in this context from my point of view

        Anyway, thanks for correct me

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The version of Power BI Desktop I have says January 2020, which is the same one I am taken to from the link on the Report Server page. And the only visual I am using in the test report is a table. Is there anything else to consider which may be causing this?

      • KBO's avatar
        KBO
        Memorable Member
        6 years ago

        Hi Anonymous ,

        which datasource do you use? May be you need a driver on your lacal machine to load the data and one driver in the machine where the Report Server is hostet :).

         

        Best,

        Kathrin

         

         

         

         

        If this post has helped you, please give it a thumbs up!
        Did I answer your question? Mark my post as a solution!