“Surely the API supports unlimited exports and totals. We’ll just write a helper service leveraging the API”
It was time to explore workarounds…
Generally speaking, workarounds for data export fall into 2 categories:
1) Access the underlying data cube
2) Intercept and reinterpret
I will cover several methods for each:
Access the underlying data cube:
Under the hood, Power BI stores data in an anlaysis services cube. A developer can access this cube directly by determining the port the cube is running on and accessing it using a data tool. For example you can do so with DAX Studio or SSIS.
However any solution involving this method has two very non user-friendly problems. 1) It requires a high level of technical expertise. 2) Totals cannot be inferred. While you can access the full dataset this way, there is no way to tell what totals you are using within Power BI.
This was turning into quite a nasty little problem. However, I was determined to push through this and find a solution. “If I can’t get to the data from the front end, and I require no developer interaction… I guess its time to play dirty.”
Continue reading Part 3 to check out my research into intercept and reinterpret methods