kevhav's avatar
kevhav
Icon for Continued Contributor rankContinued Contributor
4 years ago
Status:
Accepted

Native query for Amazon Redshift - not working in the Service

We found the new native query for Redshift feature works great, in the October version of Power BI Desktop. But after publishing the .pbix (in DirectQuery mode) to a workspace in the Power BI Service...
Reports
kevhav's avatar
kevhav
Icon for Continued Contributor rankContinued Contributor
4 years ago

The error message is:

Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError
QueryUserError: Expression.Error: Native queries aren't supported by this value.. #table({"Name", "Data", "Kind"}, {}). . The exception was raised by the IDbCommand interface.
Correlation ID: ________________
Activity ID: ________________
Request ID: ________________
Time: Fri Oct 15 2021 13:02:07 GMT-0700 (Pacific Daylight Time)
Service version: 13.0.16934.66
Client version: 2110.1.08076-train
Cluster URI: https://wabi-west-us-b-primary-redirect.analysis.windows.net/

 

Completed Ideas