Semantic Model not Refreshing online, only in Desktop

[dkdirenzo]

Hi, I published a PowerBI report to the online service and tried to refresh it this way. The report has 2 different data sources but I successfully refreshed it a few months ago, I only updated the source to a new file in the same database.

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":

Does anyone know how to resolve this so I don't have to keep opening in PowerBI desktop, refreshing, and re-publishing?

[Anonymous · Accepted solution]

Hi @dkdirenzo ,

Based on the error message you provided, I checked the relevant problem documents, it seems like the error is related to privacy levels for each data source.

You can follow my steps below to troubleshoot if the issue is caused by inconsistent "Privacy setting" settings:

1.Open the corresponding PBI desktop local file first, and go to File->Option and settings->Options->Privacy and choose the first option

2.Then go to Data Source Settings and make sure that the Privacy setting settings of all data sources connected to your dataset are consistent

3.After configuring the Power Bi desktop, you can republish and try to reconfigure the data source definition for the data source of the related dataset to ensure that the Privacy level configured on the Service is consistent with that of the Desktop.

If the above methods cannot help you troubleshoot the problem, you can provide your detailed error information so that we can better help you solve the problem.

Best Regards,

Albert He

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

[dkdirenzo · Accepted solution]

Hi, I did not have the option to change settings in privacy above but I did find it helpful to first change the individual data source privacy settings to Organizational instead of None. Then I updated and reconfigured the gateway and it worked. Thanks!

[Anonymous · Accepted solution]

Hi @dkdirenzo ,

Based on the error message you provided, I checked the relevant problem documents, it seems like the error is related to privacy levels for each data source.

You can follow my steps below to troubleshoot if the issue is caused by inconsistent "Privacy setting" settings:

1.Open the corresponding PBI desktop local file first, and go to File->Option and settings->Options->Privacy and choose the first option

2.Then go to Data Source Settings and make sure that the Privacy setting settings of all data sources connected to your dataset are consistent

3.After configuring the Power Bi desktop, you can republish and try to reconfigure the data source definition for the data source of the related dataset to ensure that the Privacy level configured on the Service is consistent with that of the Desktop.

If the above methods cannot help you troubleshoot the problem, you can provide your detailed error information so that we can better help you solve the problem.

Best Regards,

Albert He

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

[Anonymous]

Hi Albert,

Hope you can help me here. I got same issue than Mr. dkdirenzo (Semantic Model not Refreshing online, only in Desktop).
Despite I changed the privacy levels to "Combine data according to your privacy level setting for each source" and review the consistency of sources, It's not refreshing in the website.

I have connections to local drives and a database. The database connection is the one failing since 2 weeks or so. Before that, I could sing in without problem, in the configure menu of the semantic model, inside the data source credential section. 

I also updated the personal data gateaway, but it's not working still. 

This is the error message:

Failed to update data source credentials: An error happened while reading data from the provider: 'One or more errors occurred.

Activity ID:	40dafdca-255c-4e65-99ec-f5fc4154dceb
Request ID:	688cf9ca-8866-ecbe-1112-1aec49b0ddde
Status code:	400
Time:	Mon Apr 08 2024 15:17:10 GMT+0200 (Central European Summer Time)
Service version:	13.0.23021.56
Client version:	2404.1.18702-train
Cluster URI:	https://wabi-north-europe-c-primary-redirect.analysis.windows.net/ In the connections manage connections and gateways menu, I can see that all my connections are: Type: File Gateway cluster name:  nicolas.mosquera-rey (Personal mode) Except for the database connection which is failing:  Type: MySQL Gateway cluster name: -

[dkdirenzo · Accepted solution]

Hi, I did not have the option to change settings in privacy above but I did find it helpful to first change the individual data source privacy settings to Organizational instead of None. Then I updated and reconfigured the gateway and it worked. Thanks!

[aj1973]

Hi @dkdirenzo 

For sure you need to reconfigure the Gateway connections to the sources.

What are they?

[dkdirenzo · Accepted solution]

Hi, I did not have the option to change settings in privacy above but I did find it helpful to first change the individual data source privacy settings to Organizational instead of None. Then I updated and reconfigured the gateway and it worked. Thanks!