Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
One of my datasets sometimes gives the following error: "The 'XXX' column does not exist in the rowset. I am getting this error for a table that I have pivoted. However, in Power Query, after the pivot transformation I am not referencing anywhere the column that is raising the error. When I download the pbix file and manually refresh the file, the dataset refreshes without any problem. However, after a while the error reappears for another column that stops existing after the pivot. Why does this happen?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Explain the reason in detail and give the suggestions