Mysql MashupDataAccessError Refresh

[xskyx]

Hello,

Although it works flawlessly in Power BI Desktop application, when I upload it to cloud environment, the following error occurs with automatic renewals. It shows as if the renewal works for maximum 10 minutes but it fails before 10 minutes are up. I think it gives an error in MySQL Database operation. What could be the reason?

Data source error: [ValidateMarkupTags]{"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":"[ccon]Information is needed in order to combine data. Please specify a privacy level for each data source.[/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[ccon][{\"kind\":\"MySql\",\"path\":\"[ccon]172.16.19.17</ip>[/ccon]<ip><ip>172.16.0.0</ip></ip>;genresman\"},{\"kind\":\"SQL\",\"path\":\"[ccon]<ip>172.16.19.12</ip>[/ccon]<ip><ip>172.16.0.0</ip></ip>;SAW\"}][/ccon]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: _URUN_SATISLARI.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: d119fce3-893b-452c-bc50-28faef3ecf3c
Request ID: 0ccbd1b8-f185-2c21-26d7-c2630a25732d
Time: 2025-01-16 07:25:49Z

[v-pagayam-msft]

Hi @xskyx ,
I wanted to follow up on our previous suggestions regarding Mysql MashupDataAccessError Refresh . We would like to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @xskyx ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by us. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly. Still required any further assistance, feel free to reachout.

Thank you for being a valued member of Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @xskyx ,
Thank you for reaching out to the Microsoft Fabric Community Forum about the issue you are encountering.

Providing the resolution steps which might assist you in resolving the issue:

1.While uploading the report to the Power BI Service, the privacy settings are inherited from the Desktop file,check the privacy level settings for each data source that are same as in Power BI Desktop.
2.Configure the On-Premises Data Gateway correctly to ensure that Power BI can access the data source securely
3.Check the connections to MySQL and SQL data sources that are correctly configured and there are no network/firewall issues restrictions.

If still facing difficulty in resolving the issue, please feel free to reachout.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[collinq · Accepted solution]

Hi @xskyx ,

In the error message, you have this message:

"Please specify a privacy level for each data source"

So, please make sure that you have the "ignore privacy" setting on all the desktop connections (if that message is there).

Second, and more likely, make sure that the privacy type is the same in the Desktop as the Data Source (both "organizational" or whatever).  That has to match as well for this to work.