Data Source Error

[phinjosa]

I am getting this issue.

My data table is ok and gateways are ok, the Column 21 in the Excel connected to the PBI does not exist. And this is the issue I am having to refresh the data. Thanks for your help

Data source error: The 'Column21' column does not exist in the rowset. Table: B2B Leads.
Cluster URI: WABI-US-EAST2-D-PRIMARY-redirect.analysis.windows.net
Activity ID: bd5e579f-2e9a-4c59-824d-30b1bf72b977
Request ID: 1a2bbf90-62be-a050-af10-8c335666f421
Time: 2024-06-24 21:11:01Z

[blopez11]

Seems like at one point it did exist.  You'll need to open the pbix source file for your report, select Transform data form the ribbon, inspect the applied steps for the query B2B Leads, modify the step that is referencing Column 21.  Hope this helps,

[phinjosa]

Thanks!, the thing is that column 21 never existed and I won't see any applied steps refering to a 21 column 😞