Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...

Hi Andre,

Thank you for reaching out to me. I'm sorry to hear that you're experiencing issues with the Power BI Service refresh. It seems like you have already raised a support ticket with Microsoft and provided them with the necessary details. That's a good step towards resolving the issue.

Based on the information you've provided, it appears that the issue is related to pre-existing legacy SharePoint lists in classic team sites that are empty, causing the Power BI Service refresh to fail using Implementation 2.0. You also mentioned that the same issue is occurring with power queries where the ID column has been removed and the list has data.

It's possible that there may have been some changes on the Power BI Service that could be causing this issue. I would recommend continuing to work with Microsoft support to resolve this issue as they would be best equipped to diagnose and fix any problems.

In the meantime, if you have any other questions or concerns, please feel free to reach out to me. I'm here to help in any way I can.