DataSet not refreshing says The last refresh attempt failed because of an internal service error.

[Mattw112]

My DataFlow is connecting and getting data.

When I try to refresh my data set every time it is saying "The last refresh attempt failed because of an internal service error. "

If I open the dataset in Desktop via pbix.. everythign is fine, I see all the latest rows... there are no connection errors or issues...

Not sure what is going on?

How do I fix this?

Thanks,

Terry

[v-xiaoyan-msft]

Hi@Mattw112,

Please take a look at the troubleshoot refresh scenarios.

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

If it does not work, please provide more details.

Hope it helps.

Best Regards,
Caitlyn Yan

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

[Mattw112]

yes, the two basic items are fine.

None of the errors match what I am seeing... internal service error

Thanks,

Terry

[Mattw112]

I ended up fidning some blank values that I think were messing it up.  Would be nice if the Microsoft error messages were more helpful.  Having to send session info to Microsoft support every time is a pain.