Importing Formulas from an Excel Data Table into PowerBI

[rkoelker]

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.

[v-lili6-msft]

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

[Anonymous]

@rkoelker 

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."