Dataset refresh failed

[Anonymous]

I got this error while trying to refresh the dataset. I dont know why because it was fine when I try to refresh it from the desktop. Does anyone know why and how to resolve it? I try to re-publish over and over again and it still happening.

[nandic · Accepted solution]

@Anonymous ,

If you have error in your Power BI desktop version, it will show you error when you enter Power Query.

But if you do not use this column in report everything seems fine, charts are working, slicer are working.. All good.
But once you publish it to Power BI Service and try to refresh it will return the error and you will not get refreshed report.

So first of all, check your Power Query for any errors and try to fix it there.
Here is a post that might help you: https://community.powerbi.com/t5/Desktop/DataFormat-Error-We-couldn-t-parse-the-input-provided-as-a/...

[Sujit_Thakur · Accepted solution]

Dear @Anonymous  ,

As error shows , it is telling that your Data has some issue in Date column , please check data type of date column in desktop , and make sure format of your preloaded date is same as format of date column which is going to be added after refresh .


Please let me know if problem is still there .i will be more than happy to help
if this helped you . Please accept as solution .
and please dont forget to give kudos !!
regards,
Thakur Sujit

[nandic · Accepted solution]

@Anonymous ,

If you have error in your Power BI desktop version, it will show you error when you enter Power Query.

But if you do not use this column in report everything seems fine, charts are working, slicer are working.. All good.
But once you publish it to Power BI Service and try to refresh it will return the error and you will not get refreshed report.

So first of all, check your Power Query for any errors and try to fix it there.
Here is a post that might help you: https://community.powerbi.com/t5/Desktop/DataFormat-Error-We-couldn-t-parse-the-input-provided-as-a/...