Power Bi service refresh error

SravanKandibanda · 2025-03-24T15:00:14+00:00

There was an error rendering this rich post.

Hi All,

I am encountering a data source expression error in Power Bi service when scheduling a refresh indicating that a column was not found and with a error message "The exception was raised by the IDbCommand interface" . I have verified my data source, and everything appears to be in order. Additionally, when I refresh the data on my Power BI Desktop, the refresh completes successfully in under 30 seconds. I am unsure how to proceed in this scenario and would appreciate suggestions for resolving this error. The following is the exact error message -

Data source errorExpression.Error: The column 'Column2' of the table wasn't found.. Column2. . The exception was raised by the IDbCommand interface. Table: Destination."

Accepted answers

All comments

MyBalanceNow

Looks like Power BI Desktop refreshes fine, but Power BI Service fails due to a missing column. Make sure the data source in the service matches your local version, re-upload the dataset, and check if Column2 exists in the service's data source. If the issue persists, republish the dataset and verify your gateway settings.

mybalancenow

James Poole

Hi did you ever find a solution for this issue? We're encountering the same thing, 'Column2' wasn't found. Desktop refreshes fine.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…