SQLServer 2019, Polybase and Tabular Model

grajee 341 Reputation points
2020-09-27T16:04:45.72+00:00

All,

From SQL Server 2019, how do I connect to SQL Server Analysis Server (Tabular Model)/Azure Analysis Service using "CREATE EXTERNAL DATA SOURCE". I would like to connect to it using Polybase and extract data from the Tabular data model.

I installed the latest drivers for the Tabular model: https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions

Thanks,
grajee

P.S :- https://stackoverflow.com/questions/64083298/tabular-model-and-analysis-service-and-odbc

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,815 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,247 questions
0 comments
Accepted answer
  1. David Browne - msft 3,771 Reputation points
    2020-09-27T16:18:17.623+00:00

    Polybase supports ODBC data sources, as well as a few additional non-ODBC data source.

    Analysis Services has no ODBC driver. It's got an OleDB provider and an ADO.NET driver.

    For SSAS you can use a Linked Server instead of Polybase.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest