Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Strategy for deploying Report Server

Hello everyone.   I'm just getting started with Power BI. My goal is to deploy a Report Server only for internal enterprise use. I've already tried to install it, and create some report, and for no...
Direct Query
linked server
views
  • blynchdata's avatar
    blynchdata
    5 years ago

    If you have SQL Server and are going to deploy the Power BI reports to it, we find that the SSAS Tabular Model works well. The process is generally: ETL that data with a tool like SSIS into database tables, create views of that data and feed that data into the SSAS Tabular Model. 

     

    Open Power BI for Report Server, connect to the tabular model, create your report, save it to the Report Server. We find this performance so far acceptable. 

blynchdata's avatar
blynchdata
Resolver I
5 years ago

If you have SQL Server and are going to deploy the Power BI reports to it, we find that the SSAS Tabular Model works well. The process is generally: ETL that data with a tool like SSIS into database tables, create views of that data and feed that data into the SSAS Tabular Model. 

 

Open Power BI for Report Server, connect to the tabular model, create your report, save it to the Report Server. We find this performance so far acceptable. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks.

    I'll try and let you know if it's solved.

    Regards,

    J.