analysis services native query

Bharath-4205 80 Reputation points
2023-07-14T15:38:46.7433333+00:00

Hello,

when trying to import the data using the native query, we are getting an error "native queries aren't supported by this value". We are using ODBC here.

my understanding is ODBC allows native queries.

Appreciate your inputs here

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
428 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 24,106 Reputation points Microsoft Employee
    2023-07-14T23:58:36.5+00:00

    Hello Bharath,

    Welcome to the Microsoft Q&A platform.

    Are you using GET DATA to create the data source by selecting “ODBC”?

    And when using the native query to build the expression, you get this error.

    Please correct me if this is not correct

    if this is correct, Value.NativeQuery doesn't support ODBC data sources. But ODBC has a special function for native query.

    Please see the below reference document:

    https://learn.microsoft.com/en-us/powerquery-m/odbc-query

    Odbc.Query(connectionString as any, query as text, optional options as nullable record) as table  
      
    Example: Odbc.Query("dsn=your_dsn", "select * from Customers")   
      
    output: table  
    

    I hope this helps. let me know if you have any further questions.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful