Service error message but what does it mean?

Question

Data source 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":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"PRD-SO-DW1.iia-cloud.com;master\"},{\"kind\":\"SQL\",\"path\":\"PRD-SO-DW2.iia-cloud.com;master\"},{\"kind\":\"SQL\",\"path\":\"softphone.secondary.database.windows.net;softphone\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: AdviserRole.&nbsp;Query works fine in desktop so what is wrong with it?&nbsp;thanksMike

greg_deckler · Answer

masplin&nbsp;- Very difficult to troubleshoot these kinds of things.&nbsp;ImkeF&nbsp;and&nbsp;edhans&nbsp;might be able to tell what is going on but you might have better luck&nbsp;checking the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/IssuesAnd if it is not there, then you could post it.If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

amitchandak · Answer

masplin , it is showing some error in gateway error.
refer if this can help
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoothttps://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/https://www.youtube.com/watch?v=mGnNn6gnrKk

v-yingjl · Answer

Hi&nbsp;masplin&nbsp;,
Based on the error message, the reason that cause this issue is the&nbsp;Privacy Level setting for this data source when you configure the data source in the gateway page.
Please set the privacy level in power bi service which should be the same as in the desktop in data source settings.

Here are the simliar issues you can also refer, hopes to help you:

Information is needed in order to combine data&nbsp;
Power BI service - Information is needed in order to combine data Table&nbsp;
Information is needed in order to combine data error even with same Privacy Levels in Desktop/Server&nbsp;

&nbsp;
Best Regards,Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

masplin · Answer

I tried that because tht's what error suggested, but it was actually same as my other error. Badstaging of extenral data queries as solved by Microsoft support on this thread

Bad staging of Data Queries

seems if the model refreshes in desktop but not in service this is the number one thnig to check

Pity error messages areso misleading and unhelpful

Forum Discussion

Service error message but what does it mean?

4 Replies

Related content

error message

Error message : Expression.Error

Power BI Service error

Error message on notebook sql

Power BI Service Error Message