Forum Discussion

xskyx's avatar
xskyx
New Member
1 year ago
Solved

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 fo...
Dataflow
  • collinq's avatar
    collinq
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.