Power Bi service refresh error

SravanKandibanda
SravanKandibanda
in Integrations and extensibility

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."

Answers

  • MyBalanceNow
    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

Categories