topic Re: Update formula in excel automate in Report Server

Update formula in excel automate

Anonymous — Fri, 15 Apr 2022 03:11:39 GMT

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

Re: Update formula in excel automate

v-luwang-msft — Mon, 18 Apr 2022 05:55:43 GMT

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

Re: Update formula in excel automate

v-luwang-msft — Wed, 27 Apr 2022 02:38:50 GMT

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