Issues with scheduling refresh on power Bi Desktop

[Anonymous]

I want to schdule a refresh. I keep getting an error message telling me that it failed to update the data source credentials for my dataset. This is the first time I'm trying this but it's not working. Any help? Thnks.

[Pragati11]

Hi @Anonymous ,

Did you check your database credentials set up for this refresh?

Thanks,

Pragati

[negi007]

@Anonymous are you using direct query. Pl. refer to below links

https://docs.snowflake.com/en/user-guide/oauth-powerbi.html#:~:text=present%2C%20but%20disabled.-,Failed%20to%20update%20data%20source%20credentials%3A%20ODBC%3AERROR,%5B28000%5D%20User%20access%20disabled.&text=If%20you%20want%20this%20user,Snowflake%20from%20Power%20BI%20again.

Snowflake user present, but disabled.

Failed to update data source credentials: ODBC:ERROR [28000] User access disabled. Contact your local system administrator.

In Snowflake, run desc user <username> to verify if the disabled attribute is set to true. If you want this user to be allowed, run alter user <username> set disabled = true;. Try to access Snowflake from Power BI again.

[parry2k]

@Anonymous you have to enter dataset credentials in power bi sevice where you are setting up the schedule.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[amitchandak]

@Anonymous , refer if these issues

https://community.powerbi.com/t5/Issues/Error-in-connecting-to-Snowflake-in-PowerBI/idi-p/837459

https://community.powerbi.com/t5/Issues/Snowflake-SSL-error-in-both-Power-BI-Desktop-and-Power-BI/idi-p/969540