Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have an excel book with 10s of thousands of calculations run to generate output from input into a row.
So I made a canvas app, and now must translate all the math over. What is the most effective way to translate this over?
Import your excel wokr book into power bi and it should recognize the calculaitons
@Anonymous
It turns all the tables into static text while it imports. So you get the calculation results but not the calculations.
Unless you know of some way around that?
can you send an example of the calculation you are importing ?
The calculations dont seem that intense so I would duplicate the measures in DAX or just have the excel workbook do all the work and connect your power bi report to the output from excel.
I'm trying to avoid DAX because long term we are translating everything to SQL down the road.
Do you happen to know how to connect an Excel book to Power BI in a way that we can strill write to it using PowerApps input fields?
Hi @Humanity,
If these formulas are designed on the excel data table, you cna try to use the 'import' feature to import the whole workbook to power bi desktop. (it include current formulas)
Import Excel workbooks into Power BI Desktop
If not, I think you need to manually convert these formulas with power bi Dax expressions logic. (since power bi data mode table not include column/row index, so these excel DAX functions not fully works on power bi desktop side)
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.