Forum Discussion
Native query for Amazon redshift - not working in the service
Hi everyone,
Whenever I'm using Direct query to load data from Amazon redshift below error is coming:
Underlying error code: -2147467259
Underlying error message: Native queries aren't supported by this value.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: #table({"Name", "Data", "Kind"}, {})
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: f6bf08bf-ff6f-4d52-b84c-0314d165f7d2
Request ID: 7a286470-ccfb-9603-3b92-1a98adf4e7cb
Time: 2022-05-31 07:11:01Z.
Hi Anonymous
(1) check your connection settings,
Integrate Power BI with Amazon Redshift for insights and analytics | AWS Big Data Blog
(2) or try the method in this post
Solved: Re: "Native queries aren't supported by this value... - Microsoft Power BI Community
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-xiaotangCommunity Support
Hi Anonymous
(1) check your connection settings,
Integrate Power BI with Amazon Redshift for insights and analytics | AWS Big Data Blog
(2) or try the method in this post
Solved: Re: "Native queries aren't supported by this value... - Microsoft Power BI Community
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.