PBI Dataset Refresh error ?.

[ravirayala4252]

Hello Experts

My dataset refresh is failing due to various errors. But i notice no errors in the Power Query side. Please let me know is this due to datasoure issue or any transformation issue.Not able to figure it out why ?.

[pratyashasamal]

Hi @ravirayala4252 ,

I had a similar issue. I noticed there was one row that was blank/null. I removed it by going Home -> Remove Rows -> Remove Blank Row, and then re-doing whatever transformation I neeed to do before getting the error, and am no longer recieving an error.

Here is the PowerBI article I used to fix my issue - Remove blank/null rows: Solved: Delete all the row when there is null in one colum... - Microsoft Power BI Community

For example :-

Check each step for errors, it may be your data source. I had this error with a query that referenced another query (query A is the referenced query, query B is the query showing the error). Query A has a conditional column I added, but the data source was missing data in the column targeted by the conditional column. Query A loaded but with errors. Query B references A, but won't load because the errors in the conditional column don't permit query B to download the data. I fixed query A, and this cleared the error in query B.

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[ravirayala4252 · Accepted solution]

Hai 
My problem was solved, Actually this error is due to some problem at Soure side not in Power Query.

Thank you !..