Two snowflake users in PowerBI services

Hi asifrasool ,

Based on the information you provided, the core of the issue appears to be using a different Snowflake user and different privacy level settings for each report in Power BI. Here are some insights and steps you can take to troubleshoot and resolve the potential issue:

1. Ensure that the data source credentials for both Snowflake users (management_user and marketing_user) are configured correctly in their respective workspaces. This includes verifying that the credentials have not been inadvertently overwritten or expired.
2. Differences in privacy levels ("public" for management_user and "private" for marketing_user) may affect refresh behaviour. As you are using different databases and schemas, consider setting both to the same privacy level, preferably the "organisation" level, to maintain a balance between data isolation and functionality. For more information on privacy levels, see Privacy levels in Power BI Desktop.
3. Check the scheduled refresh configuration for both reports in their respective workspaces. Ensure that there are no conflicts or limitations that could affect the refresh operation.

Best Regards,

Ada Wang

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