Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 alte...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • Neverwish's avatar
    Neverwish
    Regular Visitor
    2 years ago

    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.