REFRESH ERROR: Unable to read data from the transport connection

[jts_]

Hi, I am running into an issue of refreshing the data. The last time of refreshing data was on 7/3/2023, and there was no issue during the refresh.

I was able to detect the part running into the issue is the data source from Share Point folder (this folder contains several of power automated data, and it is automated on daily basis). 

The odd thing is that the preview of data in Power Query looks fine, but once I started to refresh the data, I received this error message.

Few things I've tried but not working:

1. Clear Cache

2. Update the Power BI desktop to the latest version (June 2023)

I appreciate your suggestions and advices in advance!

[v-yangliu-msft]

Hi  @jts_ ,

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

Solved: Publishing error - Microsoft Fabric Community

Best practice with dataflow and dataset - Microsoft Fabric Community

Unable to read data from the transport connection:... - Microsoft Fabric Community

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

[amitchandak]

@jts_ , seem like issue with conenction.

In case of service edit data source credential from dataset settings

in case of desktop, Hoem Tab -> Transform data -> Data Source Setting-> Clear permission

give credentials again and try