data querry error reorder

[TineM]

Hi,
I have a create a dashboard which gets the data from smartsheet.
The smartsheet get updated from time to time with different cell content or new added rows.

If I recently click the refresh data buttom the data querry gives me an error message:
I have not changes anything on the column order in smartsheet it's a report.
Any idea how to fix it?
Thanks

[TineM · Accepted solution]

Thanks all,
I check the column error message and found the problem. There was an error in smartsheet which I was able to fix and now it's working!

[v-xinc-msft]

Hi @TineM ,

I am happy to learn that you found the cause of the problem and fixed it.

Please accept your own reply as a solution, it will make it easier for other users who may be experiencing the same problem to find a solution.

Thank you for your understanding!

Best regards,

Lucy Chen

[v-xinc-msft]

Hi @TineM ,

Or if you still don't know how to give us accurate error information.

Could you please provide sample files here? We could offer you more help if we have information in detail. And what you expect the output to be. There is sensitive data that can be removed in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TineM]

@ToddChitt , @danextian , @fahadqadir3 ,
 not 100% sure where to fine the error message. 
Is the what you mean?:
= Table.ReorderColumns(#"Kept Errors", {"Row Number", "RowNumber", "Sheet Name", "Primary", "Article CC Developer", "Article Development Type", "Article Factory Appropriate SEC Claim", "Article Factory Confidence Level (biz) >75%", "Article Factory Confidence Level (BOM errors)", "article Number", "Article Product Manager", "Article Retail Intro Date", "Article Senior Developer", "Article Status", "Biomech. Test + MST", "briefed after", "CAD available in CP", "Category Marketing Line", "Colorway Name", "CR1 AC-T Delivery date HZO", "CR1 AC-T sample delay reason", "CR1 AC-T sample needed?", "CR1 AC-T sample sent on time?", "CR1 Actual ex-factory date", "CR1 Actual ex-factory date AC-T samples", "CR1 Actual ex-factory date early wear test", "CR1 AWB# AC-T sample", "CR1 AWB# DEV sample CCH", "CR1 CAD confirmed on", "CR1 CAD Confirmed On Time?", "CR1 delivery date HZO", "CR1 Dev Handover date", "CR1 Dev Handover on time", "CR1 Dev Sample delay reason", "CR1 Dev sample needed?", "CR1 early warning AC-T samples", "CR1 Early wear test delay reason", "CR1 Early Wear Test needed", "CR1 Early Wear Test send on time", "CR1 FF stack heights mm", "CR1 Material confirmed on", "CR1 Materials confirmed on time?", "CR1 Material confirmation deadline", "CR1 Dev Handover Deadline", "CR1 Cad Confirmation Deadline", "CR1 Models Weight g", "CR1 Pattern Confirmation deadline", "CR1 Pattern confirmed on", "CR1 Pattern confirmed on time?", "CR1 Planned ex-factory date", "CR1 Planned ex-factory date AC-T samples", "CR1 Planned ex-factory date early wear test", "CR1 RF stack heights mm", "CR1 Sample sent on time?", "CR1 Tech Pack confirmed on time?", "CR1 Tooling confirmation deadline", "CR1 Tooling confirmed on", "CR1 Tooling confirmed on time?", "CR1 Warning early wear test sample delay", "CR1 Warning sample delay", "Fit Test + MST", "Halo Calendar", "helper column", "Helper SEC", "Intended Use", "LO Developer", "Marketing Department", "Model count", "Model Number", "Model Status", "Overall Article Test Status ""Ready for BUY READY""", "Overall FGT Result", "Performance Test + MST", "Sales Line", "Sustainability and Ethics Compliance (All)", "Sports Category", "Target Weight", "Test Analyst", "Test Level", "Wear Test + MST", "Weight critical model", "Article 9oo10", "Days Countdown BUY READY", "CR2 AC-T Delivery date HZO", "CR2 AC-T sample delay reason", "CR2 AC-T sample needed?", "CR2 AC-T sample sent on time ?", "CR2 Actual ex-factory date", "CR2 Actual ex-factory date AC-T samples", "CR2 CAD Confirmed On Time?", "CR2 Color & Material Team detailed comments", "CR2 Delivery date HZO", "CR2 Dev Handover on time", "CR2 Dev sample needed?", "CR2 Dev Sample delay reason", "CR2 FF stack heights mm", "CR2 Materials confirmed on time?", "CR2 Models Weight g", "CR2 Pattern confirmed on time?", "CR2 Planned ex-factory date", "CR2 Planned ex-factory date AC-T samples", "CR2 RF stack heights mm", "CR2 Sample sent on time?", "CR2 Sample status against CAD & Material Map", "CR2 Tech Pack confirmed on time?", "CR2 Tooling confirmed on time?", "Final Weight Range in g", "MCS sent to NUREG", "article creation date MP", "MCS", "CR2 CAD confirmed on", "CR0 Models Weight g", "Final Weight Range in g.", "CR0 AC-T Delivery date HZO", "CR0 AC-T sample needed?", "CR0 AC-T sample sent on time?", "CR0 Actual ex-factory date", "CR0 Actual ex-factory date AC-T samples", "CR0 CAD confirmed on time?", "CR0 delivery date HZO", "CR0 Dev Handover on time", "CR0 Dev sample needed?", "CR0 Dev Sample sent on time?", "CR0 FF stack heights mm", "CR0 Materials confirmed on time?", "CR0 Pattern confirmed on time?", "CR0 Planned ex-factory date", "CR0 Planned ex-factory date AC-T samples", "CR0 RF stack heights mm", "CR0 SEC Check", "CR0 Tech Pack confirmed on time?", "CR0 Tooling confirmed on time?", "Lead Colorway", "Lead Time", "T1 Factory Short Code"})

 

[danextian]

One or more columns in that query will show an error for all or several rows. Click on one of the cells to show the error.

[danextian]

Hi @TineM 

A lot of possible reasons. It could be due to incorrect data type - text was entered for a column that's supposed to contain numbers only or date is in the wrong format - for example 1/16/24 is entered as 16/1/24 and your culture is US so 16/1 couldn't be read as a valid date. The error will usually tell you what's gone wrong.

[ToddChitt]

What's the error message?

[fahadqadir3]

When you refresh whats the error you faced ? if your data is different from the data type you will got the error data type mismatch.data type mismatch error occurs when a value is entered that doesn't match the data type that is expected.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!