Forum Discussion
Importing Formulas from an Excel Data Table into PowerBI
I have developed a rather large and complex data table in Excel in order to produce various reports from Service Now. Service Now does not provide the necessary items that I need to report on so in addition to 24 columns of raw data, I have created 53 columns of formulas the produce granular results to over 36 thousand records.
Two things:
1. I would like to be able to import the file into PowerBI such that it includes the formulas.
2. Once I've done proof of concept, I would to eventually integrate it with the live data from Service Now (versus a static data dump).
So, without having to completely re-create each of the formulas, is there a way to import them all?
Thanks.
2 Replies
If you import an excel file it can bring in any value created by your formulas. So if you created a calculated column in excel, Power BI will just see it as a column of values. So in that sense, you don't have to recreate anything, just make sure your formulas return a value stored somewhere in your workbook.
There is a Power BI content pack for ServiceNow
https://powerbi.microsoft.com/fr-fr/blog/explore-your-servicenow-data-with-power-bi/
---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."hi rkoelker
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
Regards,
Lin
