Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have installed an On Premises gateway on a server.
I am able to access the SQL Server from the server on which the gateway is installed and the PBIX/report development was done from the same server.
But getting the error in Powerbi Service when trying to refresh the dataset/semantic model :
Error :
So what should be the next steps?
Is there any settings within the gateway wherein we can exlcude encrypt credential similar to how we did in Powerbi desktop similar to below link :
Solved! Go to Solution.
Has nothing to do with the gateway. On the SQL server renew the expired certificates and then restart the SQL Server service.
Has nothing to do with the gateway. On the SQL server renew the expired certificates and then restart the SQL Server service.
Hey @lbendlin
Thank you for your response.
But my query was more on :
We were able to connect to the database via Powerbi desktop by disabling encrypt connection, so is there any similar setting across On Prem gateway set up/Powerbi service.
There is not. We had a ticket open with Microsoft on that topic, and they swatted it away. They have no interest in allowing unencrypted connections on the gateway.