Why fail to refresh data but success in power query?

[YunJ]

Hi,

I want to refresh the dataset, it shows error. When I go to power query, it refresh successfully. After I click close and apply, nothing new refresh... 

[YunJ · Accepted solution]

Change date type in advanced editor can solve it.

[v-xulin-mstf]

Hi @YunJ,

Does your data source on your local?
Please check credentials of data source.

About refresh troubleshooting, please refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

Best Regards,

Link

[amitchandak]

@YunJ , click on that column showing red. some error should be there in power query

[YunJ]

Hi,

I don't think that's the problem. There is error because it is null. When I used the previous dataset which loaded successfully, there is also error in the column but nothing influenced.

Even if I fix the error, it still cannot refresh.

Please find the pbix file here:

https://www.dropbox.com/s/om3z8h7qqdfb82q/SBD.pbix?dl=0

Thanks for your time.