Forum Discussion

bp's avatar
bp
Frequent Visitor
9 years ago
Solved

Complete end to end on premises solution using Power BI

Looking for information on the best design for a complete end to end on premises solution using Power BI   The data is in SQL server 2016 and the requirement is to keep everything (including public...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi bp,

    Firstly, from your description, you want to use on-premises SQL Server 2016 Reporting Services to deploy and manage reports within your organization. Currently, besides creating traditional, paginated reports, you can also create mobile reports that are optimized for smartphones and tablets. Moreover, you have a modern web portal where you can view all your reports in one place. These features have been available in SSRS 2016, for more details, please review this blog.

    Secondly, when you manage reports in Power BI Service, it is also safe. For more details about Power BI Security, please review this article.  

    Thirdly, when you connect to SSAS database via “Connect Live” option, on-premises gateway is required to display the reports of SSAS data source in Power BI Service. On-premises gateway is not required if you only display the reports of SQL Server data source in Power BI Service.

    In addition, as you want to refresh your datasets in Power BI Service, you would need to add SSAS data source and SQL Server data source under the on-premises gateway. And please note that when you connect to SQL Server or SSAS via DirectQuery connection, there is no option to configure scheduled refresh in Power BI Service.  Scheduled refresh is only available for imported datasets. For more details, please review this article.


    Thanks,
    Lydia Zhang

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Can you be more specific in terms of your requirements? You seem to have all of the components that you need SQL 2016 and Power BI Desktop I assume. It is unclear at the moment whether or not what kind of infrastructure, if any, needs to be in place to support refresh. You could design this in a bunch of different ways depending on the requirements and load. Do you want high availability? 

  • bp's avatar
    bp
    Frequent Visitor
    9 years ago

    Hi,

     

    the biggest requirement is that everything stays on premises and away from anything cloud based (including Azure) for security purposes - I know this isn't possible at present but it has been promised (?) soon .... and was demo'd at Ignite

    https://myignite.microsoft.com/videos/2898

     

    the data requirement is to have Power BI desktop or Pro connect to SQL Server using Direct Query, connect to SSAS using Direct Connection - I'm wondering if that means an On Premises Enterrprise Gateway is needed as well ....

     

    The refresh rate isn't so important right now - daily is probably enough - but this will probably increase to hourly

     

    Thanks for your help,

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi bp,

      Firstly, from your description, you want to use on-premises SQL Server 2016 Reporting Services to deploy and manage reports within your organization. Currently, besides creating traditional, paginated reports, you can also create mobile reports that are optimized for smartphones and tablets. Moreover, you have a modern web portal where you can view all your reports in one place. These features have been available in SSRS 2016, for more details, please review this blog.

      Secondly, when you manage reports in Power BI Service, it is also safe. For more details about Power BI Security, please review this article.  

      Thirdly, when you connect to SSAS database via “Connect Live” option, on-premises gateway is required to display the reports of SSAS data source in Power BI Service. On-premises gateway is not required if you only display the reports of SQL Server data source in Power BI Service.

      In addition, as you want to refresh your datasets in Power BI Service, you would need to add SSAS data source and SQL Server data source under the on-premises gateway. And please note that when you connect to SQL Server or SSAS via DirectQuery connection, there is no option to configure scheduled refresh in Power BI Service.  Scheduled refresh is only available for imported datasets. For more details, please review this article.


      Thanks,
      Lydia Zhang

      • bp's avatar
        bp
        Frequent Visitor
        9 years ago

        Thanks for all your replies and help

         

        Will be watching what gets previewed at PASS with interest !

         

        B

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      9 years ago

      I believe that this functionality was announced at PASS just a couple days ago. I believe it is in the latest SQL Server 2016 Technical Preview.