Power BI Service Refresh Error - Snowflake data source

[Anonymous]

Im connecting using direct query from Power BI to Snowflake and in the power bi desktop, when I refresh the report, I dont get any issues. But once I publish the report and refresh from the service I get this error:

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", "Description", "Data", "Kind"}, {})
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: 67343424-a5de-4b1c-abaa-5eb6afebda74
Request ID: a4f3688b-5379-2437-56a7-0a34327d97dd
Time: 2021-08-25 04:43:18Z

Help is much appreciated

[wjkolesar]

Did you ever find a solution to this?  I am getting same issue on Power BI service, but no issue in Power BI desktop.  Connection from Power BI service to Snowflake does not require a gateway since both are cloud based.

[Anonymous]

Hi,

Try upgrading your gateway. It's a new feature so if we upgrade the gateway then it may solve the problem.

Regards,

Laiq

[v-henryk-mstf]

Hi @Anonymous ,

Through your description, do you mean "refresh" in powerbi desktop as shown below?

Refresh normally in the desktop indicates that the data source has been successfully connected and the correct query statement has been used.

Therefore, it may be that the corresponding gateway is not configured after publish to service. For direct query, to connect to the local data source, the gateway must be passed, otherwise the query cannot be sent to the data source. Refer to the following document to check the configuration process:

Connect to Snowflake computing warehouse in Power BI Desktop - Power BI | Microsoft Docs

In additional, you can reference related similar solutions:

SnowFlake & PowerBI "native queries aren't support by this value" - Stack Overflow

If the problem is still not resolved, please provide detailed error information and related operation screenshoots, Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.