Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
xskyx
New Member

Mysql MashupDataAccessError Refresh

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

 

 

Screenshot 2025-01-16 110021.jpg

2 REPLIES 2
v-pagayam-msft
Community Support
Community Support

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
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.