"DataSource.Error: Microsoft SQL: Invalid column name" when fetching data from Dataverse

[chapiuski]

Hello there,

I'm trying to connect a Power BI report to multiple Dataverse tables on a single Environment. Some tables seem to load just fine on PowerQuery, yet some raise the following error claiming "Invalid column name" for one, or sometimes multiple columns. I could guess the problem started after i have delted/added columns on the Dataverse table, although I cannot be 100% sure of this for some tables load fine even after I add columns to them. Also this problem happens on both Power BI Desktop and Power BI Service.

Any help would be appreciated. Thanks in advance

(I've ommited column names for placeholders)

DataSource.Error: Microsoft SQL: "Invalid column name 'cr8a2_placeholder1'.\r\nInvalid column name 'cr8a2_placeholder2'."
RequestId: TDS;(placeholder);16
Time: 2023-08-31T14:27:34.2457766Z
Details:
DataSourceKind=CommonDataService
DataSourcePath=orgXXXXXXXXX.crm2.dynamics.com
Message="Invalid column name 'cr8a2_placeholder1'.\r\nInvalid column name 'cr8a2_placeholder2'."
RequestId: TDS;(placeholder);16
Time: 2023-08-31T14:27:34.2457766Z
ErrorCode=-2146232060
Number=40000
Class=16