Forum Discussion
Connect Sql DB -SSAS-Power BI Service
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.
- Hi
If you are using SSAS Tabular then Visual Studio is your only option and best option as well
Super UserHi 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.
Thank you so much for your help!
To to move data from SQL Server to SSAS, which is good way
1. SSMS Tabular project.
2. SSIS.
Please advice on this thanks.
- GilbertQHi
If you are using SSAS Tabular then Visual Studio is your only option and best option as well