Service refresh issue - please help

Question

Hi I created a report with a mixture of a web connection (leankit), excel file on my PC and connection to SQL. This report works fine and refreshes on my desktop version but when published and refreshed on the service is fails with the following error:

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\":\"Web\",\"path\":\"https://locationdecisions.leankit.com/xxxx\"},{\"kind\":\"Web\",\"path\":\"https://locationdecisions.leankit.com/xxxx\"},{\"kind\":\"SQL\",\"path\":\"gdansk;developmentlayers\"},{\"kind\":\"SQL\",\"path\":\"gdansk;SafiPublishDb\"},{\"kind\":\"File\",\"path\":\"\\\\\\\\hamburg\\\\workfiles\\\\TEMP\\\\DAZ\\\\SAFi_SA4_priority.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: site work sub in progress.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 1aad8220-ad57-4e39-b7f7-0cb7a86a6524
Request ID: d6b7248f-279c-373e-3d34-2e687969ccf5
Time: 2024-01-02 22:04:04Z

I have tried changing all my privacy settings to the same option (tried Organizational and None) but still does not work. Any help would be much appreciated

anonymous · Answer

You probably need gateway(s) for connecting to the different data sources. Click the three dot button (elispee) next to the semantic model and go to Settings. See if there is an error in the section "Data source credentials". If yes, then you need to create the Data Source and/or Gateway for accessing the data from the sources.

d4rren · Answer

Thanks&nbsp; Thomas, all connections and creditials seem okay?&nbsp;

anonymous · Answer

Hi d4rren&nbsp;,
If I understand correctly, the issue is that you failed to refresh report on the service. Please try the following methods and check if they can solve your problem:
1.Go to the semantic model settings, ensure the privacy levels for all data sources are set consistently.

2.Check the refresh history of the semantic model in the Power BI Service to see if there are any additional details about the failure.

3.Verify the credentials for the excel, web source and SQL Server are correctly entered and have the necessary permissions to access the data.
&nbsp;
4.You should also turn on the Data connections.

Looking forward to your reply.
Best Regards,
Wisdom Wu
&nbsp;
&nbsp;

d4rren · Answer

thanks for your suggestion v-jiewu-msft&nbsp;I have checked all datasources have the same privacy level and I turned Data connections on.&nbsp; Still erroring on refresh.&nbsp; The detailed error message is in my first post.&nbsp; I was wondering if it is something to do with my leankit connection, as this is a web connection should it appear in the 'Cloud connections'.&nbsp; I added this in, still no good.&nbsp; As mentioned, this works fine on my desktop.&nbsp;

anonymous · Answer

Hi d4rren&nbsp;,
Based on my testing, I can successfully refresh. You can follow the steps below: 
1.You can check the leankit connection settings and Privacy level.