Forum Discussion

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago
Solved

Dataset refresh manually, but fails when scheduled

Hi team,  I have a Dataset whose refresh need to be scheduled. Initially when I triggered the refresh it throws up a error with code "-2147467259". I searched and found the error was because of tr...
Need Help
  • M0hamedFazil's avatar
    M0hamedFazil
    1 year ago

    Finally, found the solution.
    I have found the root of the problem and it seems to be the appending of two tables. I have checked with different possibilities and all the way seem to refresh, but not the append one.

    initially, I appended the large table with small one and this throws the error. By appending the sammler table to large table, The problem is fixed. 

    I can now schedule the refresh and the dataset is refreshed at the scheduled time

    Regards 
    Fazil M

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
1 year ago

Hi. Open de PowerBi Desktop original file. Refresh it. If it finishes correctly, then open the Query Editor and look for errors manually. Check at the buttons looking for Keep rows with error, something is odd and it might be a small issue in data that is preventing the refresh.

I hope that make sense

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago

Hello ibarrau ,

The Dataset refreshs manually and I have checked with all the transformations, I checked with the errors too. I didn't ignore any and I corrected those errors. Thanks for the reply and I will let know if I got to find the solution.


Regards 
Fazil M