Import Excel file (with fomula) to Power BI

[spagad6263]

Hi,

I would like to import a large Excel file with many formula to PB. Apart from the data, will the formula be imported to PB as well?

Thanks

[Ritaf1983 · Accepted solution]

Hi @spagad6263 
Yes, formulas will be imported as values.
Please refer to my example:

excel:

power bi:

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