The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have multiple data table in excel file that are used to calculate and create a new data table within the same excel file.
I would like to be able to import the file into powerbi along with its formula. So without having to completely re-create each of the formulas, is there a way to import them all?
Solved! Go to Solution.
Hi @divyaa ,
Based on your problems, here are my answers.
As Ritaf1983 says, Power BI can import data from Excel files. Also if your Excel file has Power Query or Power Pivot, Power BI can import these queries and models directly. You can read this document for a further study: Import Excel workbooks into Power BI Desktop - Power BI | Microsoft Learn
I do a simple example on it too. Firstly I write a formula in Excel file.
When I import it to the Desktop, it gives me this.
So direct Excel formulas are not imported as 'live' formulas into Power BI. Instead, the results of these formulas at the time of import are brought in. If you wish to maintain similar dynamic calculations within Power BI, you would need to recreate these using DAX in Power BI.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks folks for clearing my doubt!!!
Hi @divyaa ,
Based on your problems, here are my answers.
As Ritaf1983 says, Power BI can import data from Excel files. Also if your Excel file has Power Query or Power Pivot, Power BI can import these queries and models directly. You can read this document for a further study: Import Excel workbooks into Power BI Desktop - Power BI | Microsoft Learn
I do a simple example on it too. Firstly I write a formula in Excel file.
When I import it to the Desktop, it gives me this.
So direct Excel formulas are not imported as 'live' formulas into Power BI. Instead, the results of these formulas at the time of import are brought in. If you wish to maintain similar dynamic calculations within Power BI, you would need to recreate these using DAX in Power BI.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @divyaa
When you import Excel to Power BI, the engine reads the values you are using not formulas.
So there is no option to import the formulas.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
83 | |
64 | |
58 |
User | Count |
---|---|
246 | |
124 | |
115 | |
79 | |
78 |