Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Is there a way to have have multiple databases with 1 datasource connection, or do you manually have to add a new connection for Tabular Project on your server?
On premesis Gateway is setup and running, connecting to an SSAS tabular server.
Example I have SSAS (tab) Server called DEV.
Dev has 5 different tabular Models, tab1, tab2, tab3,tab4,tab5.
Is there a way to setup a Data source which can see all of the models? or is it only possible to have 1 model under a datasource?
Solved! Go to Solution.
@Bustardo,
When adding SSAS data source within gateway, it is only possible to add a single database in a single data source connection. You would need to add new data source connections for other different databases.
Regards,
Lydia
@Bustardo,
When adding SSAS data source within gateway, it is only possible to add a single database in a single data source connection. You would need to add new data source connections for other different databases.
Regards,
Lydia
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.