Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Connect Sql DB -SSAS-Power BI Service

  I am implementing Power BI service (reporting system ) in Professional year project,  We have 6 databases hosted on SQL Server( on premise) Step 1:   Plan is to connect all 6 databases to SSAS(On...
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Anonymous

     

    To answer your questions below.

     

    1. Yes you can certainly use SSAS to connect to all 6 databases. If you are using SSAS Tabular it is a quick and simple process to get the data from your SQL Server Tables into SSAS Tabular.

    2. If you are doing an exact copy of the tables, SSAS Tabular will do the data movement for you.

    3. Yes you will need to install and configure the On-Premise Gateway on your internal network. Once that is configured you can then connect from the Power BI Service or Power BI Desktop to your SSAS Tabular.

  • GilbertQ's avatar
    GilbertQ
    9 years ago
    Hi

    If you are using SSAS Tabular then Visual Studio is your only option and best option as well
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi Anonymous

 

To answer your questions below.

 

1. Yes you can certainly use SSAS to connect to all 6 databases. If you are using SSAS Tabular it is a quick and simple process to get the data from your SQL Server Tables into SSAS Tabular.

2. If you are doing an exact copy of the tables, SSAS Tabular will do the data movement for you.

3. Yes you will need to install and configure the On-Premise Gateway on your internal network. Once that is configured you can then connect from the Power BI Service or Power BI Desktop to your SSAS Tabular.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi guavaq,

 

Thanks for all the suggestions and your help. In your last replay you said about putting data together, so if I connect all 6 DB to SSAS through Tabular module project. I can't connect do consolidated reports ?

 

Thanks for advice in advance.

 

Mazhar(Intern)

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi Anonymous

     

    If I understand your question correctly, yes you can put all the data together from various database sources into your SSAS Tabular Project.


    Then you can connect Power BI to your SSAS Tabular Server and view the data.