Translate error message to english.

[KGuthrie-NF]

Can I get some help with this error message?  I dont understand what the problem is.

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. Please specify a privacy level for each data source."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"nf-sql1.neenah.local;Plant2Production\"},{\"kind\":\"Odbc\",\"path\":\"Driver={IBM i Access ODBC Driver};System=NFCO;CONNTYPE=2;\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Component Pouring.
Cluster URI: WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID: b8557175-ed02-407f-96a3-8fb6032625ff
Request ID: 2444316f-f9ba-4a5d-a3d7-966ee52ba519
Time: 2024-09-06 07:10:47Z

When I refresh the data set in Power BI Desktop everything works.  When the refresh happens on the schedule it doesnt work.

[v-xingshen-msft]

Hi @KGuthrie-NF ,
I haven't heard back from you in a while and wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[SaiTejaTalasila]

Hi @KGuthrie-NF ,

You can refer this settings-https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels

Please check your authentication method in semantic model settings update it and check.

If it is not working-you can check Table: Component Pouring in transform data for any issues(turn on column profiler and check the data quality at each transformation step) for any errors.

I hope it will be helpful in fixing the issue.

Thanks,

Sai Teja 

[audreygerred]

There are permissions missing at your source. The gateway probably doesn't have the right access at the source. This is why you are OK refreshing in desktop but not service.