Power Platform Community Forum Thread Details

Hello,

I have 2 issues I believe the second is related the first one:
DataSource.Error: Microsoft SQL: {"Message":"Invalid column name 'bcbi_companyid'.\r\nInvalid column name 'bcbi_companyidname'."}RequestId: TDS;08fae34f-589f-4b27-ba01-1105536607cd;3Time: 2025-02-19T17:31:23.7735577Z7790dce8-d345-4bc9-ab96-7e037212421e

I get the following error in navigation step part of the query. I add select columns part using below query. emd ones are not displayed in the column selection part and this query doesnt find them either. I had BC installed on this env. but I deleted the solutions manually.

let Source = CommonDataService.Database("---.crm4.dynamics.com", [CreateNavigationProperties = null]), #"Filtered rows" = Table.SelectRows(Source, each [Name] = "product"), Navigation = #"Filtered rows"{[Schema = "dbo", Item = "product"]}[Data], #"Selected columns" = Table.SelectColumns(Navigation, { "crcad_productcode_ex", "quantityonhand", "emd_centralwarehousestock", "emd_teklosindexstock", "emd_cevabilkomstock" }) in #"Selected columns"

Edit:

I've verified that the phantom columns remain in the tds layer using Azure Data Studio. I've tried re-creating the columns with exact names. I've bypassed the error that way. However, new columns still do not appear in the query.

I've noticed that none of the tables I've created doesn't appear in the query editor either. Something is seriously broken.

What I've tried:

Refreshing the dataflow
Recreating the dataflow
Recreating the connections
Refresh preview
Publish table
Publish all customizations
add or remove new columns from the default solution.
publish all and the table from the defaul solution
create the query in excel desktop. same error
view table metadata using xrmtoolbox metadata browser. none of the bc related columns or relationships remain.

HTTP request: GET https://<yourOrg>.crm4.dynamics.com/api/data/v9.2/EntityDefinitions(LogicalName='product')/Attributes?$filter=LogicalName eq 'bcbi_companyid'
this comes empty

Categories:

Microsoft Dataverse with Power Apps