Sudden Invalid Snowflake credentials Error on Power BI reports published on the service

[sanjyot_firke]

Hi Team,

We are suddenly facing Invalid snowflake credentials error for the scheduled Power BI reports on the server. There were no changes done to any of the snowflake configuration. The reports are directly connected to snowflake through a cloud connection on the service, Snowflake -> Power BI report.

Now we have routed them in this manner Snowflake -> AWS gateway -> Power BI report, which is allowing us to refresh the reports.

We are also able to refresh the reports after downloading it on the desktop with the same credentials as on the service.

Can someone please guide us on debugging this issue?

[v-pbandela-msft]

Hi @sanjyot_firke,

May I ask if you have resolved this issue? If so, please mark the helpful reply and "Accept as Solution".  This will be helpful for other community members who have similar problems to solve it faster.

Thank you,

Pavan.

[v-pbandela-msft]

Hi @sanjyot_firke,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @sanjyot_firke,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @sanjyot_firke,

Thank you for reaching out in Microsoft Community Forum.

Thank you @GilbertQ  for the helpful response.

please follow below steps to Invalid snowflake credentials error;

1. Make sure the service principal used for the connection has the necessary permissions in Snowflake.

2. If you're using a gateway, confirm it's correctly configured and updated.

3. Check both Snowflake logs and Power BI activity logs for any authentication or connection errors.

4. Even though the credentials are unchanged, try refreshing or re-entering them in the Power BI Service to resolve potential issues.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[sanjyot_firke]

Thank you @v-pbandela-msft for the tips.

We are working with the snowflake team and the IT team for this issue. However, they are also unable to find any issue in their settings.

We even checked the network policy and nothing seems to be changed from the company's perspective.

Inshort, still trying to find the root cause of the issue.

Regards

[v-pbandela-msft]

Hi @sanjyot_firke,

Thank you for reaching out in Microsoft Community Forum.

Since Snowflake and IT teams haven't found any changes, try these additional steps to identify the root cause:

1. Create a new Power BI report, connect directly to Snowflake, and check if it refreshes in Power BI Service.

2. Sign out and re-enter credentials under Settings → Datasets → Data source credentials to resolve potential token expiration issues.

3. Run LOGIN_HISTORY queries to look for failed authentication attempts and Go to Dataset → Refresh History to check for errors.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[GilbertQ · Accepted solution]

Hi @sanjyot_firke 

Could I suggest chatting to your snowflake administrator to see if there have made any changes blocking the cloud connections?

[sanjyot_firke]

Thank you @GilbertQ for the reply.

We did have a chat with them and they have said that they haven't blocked anything or made any changes from their side.

Regards