Forum Discussion
Issue in refresh: Gateway Mashup Error ( Native queries are not supported)
I have a power bi file which gets refreshed successfully in desktop but throws error on service as soon as the refresh is triggered .
The gateway is used to refresh and the connection is fine .
Getting below error :
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Native queries aren't supported by this value."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Kind\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Table1 .Cluster URI:WABI-US-NORTH-CENTRAL-J-PRIMARY-redirect.analysis.windows.netActivity I
[email protected]
Hi BVaibhav ,
Thank you for reaching out to the Microsoft Community Forum.
The error "DM_GWPipeline_Gateway_MashupDataAccessError" with the message "Native queries aren't supported by this value" typically arises when Power BI Service via the Gateway cannot handle certain mashup transformations or native queries that work fine in Power BI Desktop.
Please check below things to fix the issue.
1. Please check Privacy Levels:
In Power BI Desktop, Go to File --> Options and Settings --> Data Source Settings. Set all sources to Private or Organizational consistently.
In Power BI Service, Go to Dataset Settings --> Gateway Connection --> Manage Credentials. Check the Privacy Level matches what you set in Desktop.
2. If possible, move your on-prem SQL data to Azure SQL or use Power BI Dataflows to separate preparation steps.
3. Avoid using native SQL queries or complex mashup logic that references other queries dynamically. Try to simplify the query logic.
4. Please check whether you are using the latest version of the On-Premises Data Gateway. Restart the gateway service and if needed the server hosting it.
5. Re-authenticate all data sources in the Service. Use OAuth2 for SharePoint or Web sources instead of Windows.
6. If you are using a dynamic query, try to replace it with a static or move the logic to a separate query that doesn't rely on dynamic evaluation during refresh.
Please refer below links.
https://community.fabric.microsoft.com/t5/Service/Gateway-Data-MashUp-error/m-p/4624170
https://community.fabric.microsoft.com/t5/Service/Unsolveable-Mashup-Data-Access-Error/m-p/4778092
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
6 Replies
- collinq
Super User
Hi BVaibhav ,
The error message within the text states "Native Queries aren't supported by this value". That normally means that soemthing in your query is not playing nice with SQL. Bascially - the query is not "folding" anymore. To really know the issue from there is to determine what type of query you are using.
For example, a Direct Query to a SQL database will not allow for custom SQL. Or, there may be a parameter in your data that is not quire right?
The reason it might work in Desktop and not Service is the difference between the engines in the two different locations. - FBergamaschi
It is impossible to help only with the error message
Furthermore, if it is urgent as I understand, the reccomendation is to issue a support ticket as Microsoft will be faster than this forum in helping you (and they have ways to understand and fix that we here do not have)
So my 2 cents is to issue an urgent ticket to Microsoft (https://admin.powerplatform.microsoft.com/)
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
v-dineshyaCommunity Support
Hi BVaibhav ,
Thank you for reaching out to the Microsoft Community Forum.
The error "DM_GWPipeline_Gateway_MashupDataAccessError" with the message "Native queries aren't supported by this value" typically arises when Power BI Service via the Gateway cannot handle certain mashup transformations or native queries that work fine in Power BI Desktop.
Please check below things to fix the issue.
1. Please check Privacy Levels:
In Power BI Desktop, Go to File --> Options and Settings --> Data Source Settings. Set all sources to Private or Organizational consistently.
In Power BI Service, Go to Dataset Settings --> Gateway Connection --> Manage Credentials. Check the Privacy Level matches what you set in Desktop.
2. If possible, move your on-prem SQL data to Azure SQL or use Power BI Dataflows to separate preparation steps.
3. Avoid using native SQL queries or complex mashup logic that references other queries dynamically. Try to simplify the query logic.
4. Please check whether you are using the latest version of the On-Premises Data Gateway. Restart the gateway service and if needed the server hosting it.
5. Re-authenticate all data sources in the Service. Use OAuth2 for SharePoint or Web sources instead of Windows.
6. If you are using a dynamic query, try to replace it with a static or move the logic to a separate query that doesn't rely on dynamic evaluation during refresh.
Please refer below links.
https://community.fabric.microsoft.com/t5/Service/Gateway-Data-MashUp-error/m-p/4624170
https://community.fabric.microsoft.com/t5/Service/Unsolveable-Mashup-Data-Access-Error/m-p/4778092
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
- v-dineshya
Hi BVaibhav ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
- v-dineshya
Hi @BVaibhav ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
