Forum Discussion
Update formula in excel automate
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
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 RegardsLucien
2 Replies
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 RegardsLucien
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