Forum Discussion
Connect SQL server anaysis services (SSAS) to a Fabric warehouse
Good day everyone!
I've been trying to connect my tabular model on Visual Studio (SSAS) to a warehouse in Fabric.
The "Microsoft SQL server connector" did not work so I also tried using ODBC alternatives.
Just wanted to know if any of you have already tried this and if you could share tips on the type of connector and what did you put in the form (screenshots are appreciated).
The connectivity concept here is that it only supports MFA, the port (if used, I didn't) is 1433, and it should be working fine with the "SQL Server connector" using the Fabric Datawarehouse's "SQL connection string".
Finally, the connectivity, in general, It's not as straightforward as it seems; in terms of DBMS, I found it easy to connect to Fabric using Azure Data Studio but not using SQL Server MS. This is not rocket science hehe...
Here below is some of the official info I started working with and then I just scrapped blogs, google, YT, etc etc. But no direct solutions are available as far as I could read.
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
Thanks!!!
3 Replies
Hi Anonymous ,
Consider using Azure Analysis Services (AAS) as a bridge. AAS supports connections to various sources, including SQL Server and Azure SQL Data Warehouse, with robust support for MFA. You can create an AAS model that connects to your Fabric Datawarehouse and then connect your SSAS tabular model in Visual Studio to this AAS model. This approach leverages Azure's built-in support for MFA and might simplify your connectivity issues.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Either this answer is missing a lot of information about how to connect or is not a valid answer at all. Azure SQL Data Warehouse is not in the supported list which invalidates this whole answer already it seems. Please elaborate on this answer with screen shots how it is actually done.
Have you found a solution to connect to a fabric warehouse from ssas. I have the issue that I have an SSAS tabular model with a fact table that contains multiple partitions. I don't know how to connect the model from an on premises sql server to a fabric warehouse... The following is an interesting article, but still unsure how to work with the provider data source:
Convert Data Sources for Premium Migration
