Solved: Importing from CSV

M036721 · ‎07-05-2023

Hi Guys

I have a monthly dashboard which is built by getting data with a CSV file when i replace it with another similar file...refresh is failing saying few columns missings is there a way we can refresh a power bi dashboard even if the number of column reduces or added more?

ppm1 · ‎07-05-2023

See which step in your query is producing the error. It is likely one specifically referencing one or more columns by name. Hopefully it is one of the functions that supports a MissingField.Ignore parameter.

Missing Field Ignore | How NOT to break your Queries 😎 | Power Query Magic - YouTube

Pat

Microsoft Employee

View solution in original post

ppm1 · ‎07-05-2023

See which step in your query is producing the error. It is likely one specifically referencing one or more columns by name. Hopefully it is one of the functions that supports a MissingField.Ignore parameter.

Missing Field Ignore | How NOT to break your Queries 😎 | Power Query Magic - YouTube

Pat

Microsoft Employee