Power Bi service refresh error
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
-
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
Column2exists in the service's data source. If the issue persists, republish the dataset and verify your gateway settings.0
