Can the source file be replaced

[Anonymous]

Hi,

The dashboard that I am building is based on an excel source but due to some circumstances I need to change the source from excel to csv, so I have converted my source file from excel to csv, but I still haven't changed the source in Power BI, my question is that will my dashboard still function if I replace the source from file in excel format to the same file but in csv format?

Thanks.

[pranit828]

HI @Anonymous ,

It will, How I will do it is as follows.

Consider you have a "Source1" named Query which gets 10 columns.

I would create another new Query "Source1 from csv" and get all the columns in same order and same column name and type as it was in previous Query.

Once the "Source1 from csv" query looks good to implement, I will copy its M Code and paste it in the 1st query "Source1"

Regards,

Pranit

[Anonymous]

Hi,

Thanks for the reply.

I am somewhat new to power bi, so I am ask what does M code mean?

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

Go to the Home tab in Power BI and click the button Transform Data.

This will take you to Power Query. If you look at the picture below you will see how to get to the M code.  You can copy and paste that from one query to another so that everything downstream will stay the same.

I highly reccomend this book by @KenPuls 

 BTW, you can give kudos and accept solution from multiple people, so if we helped you move on, please feel free to give @pranit828  and myself those.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel