Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a dataset with two data sources - one is an excel file on Sharepoint on-premises, the other is a SQL server.
I am using an on-premises data gateway - when refreshing I get an invalid connection credentials error.
I attempted some troubleshooting by separating out the two data sources, and individually, they both refresh fine using the on-premises data gateway.
Has anyone encountered this issue before?
Thanks!
Hi @ausphil,
Did you update the credentials in the settings of dataset? Do you have the latest version of Data Gateway?
Best Regards,
Dale