The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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