Dataset Refresh Fails on Server Certificate, but Dataflow Refreshes just fine on Same Server

[li3112]

I have a report that has been failing refreshes for a couple weeks now, complaining on expired certs on the server. No certs seem to be causing the issue. I did a test and created a dataflow using the same server, and it connects just fine, so I have no idea as to why the refresh fails on the dataset but succeeds on the dataflow.

Trying to figure out if there's a network difference between dataflow refreshes and dataset refreshes. Any insight would help 🙂

[v-yangliu-msft]

Hi  @li3112 ,

This is the related document, you can view this content:

Solved: A connection was successfully established with the... - Microsoft Power BI Community

Gateway SSL Provider, error 0 – The received certi... - Microsoft Power BI Community

Error message when you connect to SQL Server - SQL Server | Microsoft Learn

Errors when applications try to connect to SQL Server in Windows - Windows Server | Microsoft Learn

Best Regards,

Liu Yang

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