Epicor to Power BI issues

Hi all new to Epicor. I have been given some old spreadsheets that have urls to Baqs in epicor which work find and refresh fine. Ive been asked to move these spreadsheets to Power Bi which was no problem at all the only problem im getting is when i hit refresh to update the data it dose not grab the data, now i have found out that i needed to install the on-premises data gateway which now lets me connect to the server but im still getting issues with the urls to the Baqs and when i click on the link to refresh it i get this.

Failed to update data source credentials: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS

Any help would be great
thanks

There needs to be a valid SSL certificate on your epicor server that power bi will trust. I sugest Certify the Web for free, easy to use and easy to manage Let’s Encrypt certificates.