Update formula in excel automate

[Anonymous]

Hi every one

Could you please help me for this

i have formula today in excel and i use this excel in power bi report i must open it every day to update this formula to effect in power bi so i want to do it automate without open this sheet

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

If there is data model in excel, you could import the whole model into power bi, the calculated column will be imported too.

https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

Alternatively, you can take your formulas and convert them into dax in Power BI by means of measure or custom column. 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien