when i refresh Microsoft dynamics 365 CRM database in power bi desktop it ask for the credential eve

[Mahmoud_12]

When i open power bi desktop to refresh the data from dynamic 365 crm , it ask me to add the credential every morning 

because of this i can't create a schedule refresh for the dashboard on power bi service

Note : i connect power bi with crm API

[v-kaiyue-msft]

Hi @Mahmoud_12 ,

You can refresh Power BI Dataset programmatically from Dynamics 365 CRM. More detailed information can be found at the link: Refresh Power BI Dataset programmatically from Dynamics 365 CRM - Microsoft Dynamics 365 CRM Tips an...

Best Regards,

Clara Gong

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

[v-kaiyue-msft]

Hi @Mahmoud_12 ,

Try using OAuth2 as the authentication method for Dynamics 365 CRM.OAuth2 provides a secure method of using credentials. More details can be found in the documentation:Authentication in desktop apps - Power Query | Microsoft Learn .

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[Mahmoud_12]

thanks brother , but this solution not working too with my issue