Forum Discussion
Error 2146232060
Hi
Does anyone know how to solve this error?
DataSource.Error: Microsoft SQL: {"Message": "Invalid column name 'cr341_outreach'.\r\nInvalid column name 'cr341_outreachname'."}
RequestId: TDS;c3c4ca27-8c52-4e6a-8835-95bebc821481;2
Time: 2025-02-25T05:42:08.7050612Z
Details:
DataSourceKind=CommonDataService
DataSourcePath=ph-peer-app.crm.dynamics.com
Message={"Message":"Invalid column name 'cr341_outreach'.\r\nInvalid column name 'cr341_outreachname'."}
RequestId: TDS;c3c4ca27-8c52-4e6a-8835-95bebc821481;2
Time: 2025-02-25T05:42:08.7050612Z
ErrorCode=-2146232060
It is showing this error in the Navigation step of the Applied step panel in Power Query
I already checked the credentials, password, and server ID...
this is in the Import Mode
3 Replies
Hi goldpartner_use,
Power Query is unable to find column names "cr341_outreach" and "cr341_outreachname".
- Column name must have been modified in the Source Database
- Ensure fields are not removed/renamed
- If you find the column name has been changed or removed, update your Query in Power Query accordingly
- If using lookup fields, expand them in Power Query.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!Hello grazitti_sapna, thank you for the answer but there are no columns named 'cr341_outreach' and 'cr341_outreachname' in the dataset.
And the error is showing in the Navigation step in the power query, so I cant possibly change or update anything in the query itself in the power query as the data is not even loaded through the navigation step.
It would be helpful if there are any other ways.
Thank youHI goldpartner_use ,
As you mentioned that these column doesn't exist in the Data set, Power Query might be referencing an outdated schema.
You can try below fixes:-1. Delete & Reconnect the Table in Power Query - Delete current table by right clicking in the queries pane and creating new table by going to get data option and selecting the table you want
2. Clearing metadata can also help - file>Option and settings> Options> Global>Data Load> clear cache automatically>clear, try loading the table again
3. If the dataset was previously loaded into Power BI, and columns were removed later, Power BI might still be trying to reference them, in Transform data, click on manage columns and see if the columns apear in the list, remove them by unchecking them
Alternatively, If you want to load the specific columns and you have a list of them add them to the query while loading the data from source
let
Source = YourDataSource,
SelectedColumns = Table.SelectColumns(Source, {"Column1", "Column2", "Column3"})
in
SelectedColumns🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
