https://community.fabric.microsoft.com/t5/Developer/Error-when-trying-to-refresh-an-import-SQL-dataset/m-p/3323402#M43416 <P>Hi all,</P><P>&nbsp;</P><P>As the title suggests, I imported a SQL dataset that I like to refresh every 24 hours.</P><P>When trying to that, I get an error that it's not allowing a connection to be made.</P><P>&nbsp;</P><P>The database is managed by another company, we do have all the credentials to acces it but its under their management.</P><P>I am guessing it has to do with whitelisting an IP-address? I read that Power-BI has a lot of rotating IP-addresses which doesn't seem like a viable solution to dump them all in the whitelist.</P><P>&nbsp;</P><P>Has anyone any tips, resources or suggestions how to achieve this?</P><P>&nbsp;</P><P>Kind regards!</P> Mon, 10 Jul 2023 14:44:24 GMT Dion_tw 2023-07-10T14:44:24Z https://community.fabric.microsoft.com/t5/Developer/Error-when-trying-to-refresh-an-import-SQL-dataset/m-p/3323402#M43416 <P>Hi all,</P><P>&nbsp;</P><P>As the title suggests, I imported a SQL dataset that I like to refresh every 24 hours.</P><P>When trying to that, I get an error that it's not allowing a connection to be made.</P><P>&nbsp;</P><P>The database is managed by another company, we do have all the credentials to acces it but its under their management.</P><P>I am guessing it has to do with whitelisting an IP-address? I read that Power-BI has a lot of rotating IP-addresses which doesn't seem like a viable solution to dump them all in the whitelist.</P><P>&nbsp;</P><P>Has anyone any tips, resources or suggestions how to achieve this?</P><P>&nbsp;</P><P>Kind regards!</P> Mon, 10 Jul 2023 14:44:24 GMT https://community.fabric.microsoft.com/t5/Developer/Error-when-trying-to-refresh-an-import-SQL-dataset/m-p/3323402#M43416 Dion_tw 2023-07-10T14:44:24Z