power bi limitations

Question

Hi,

For power bi report that involves a large data set how do we handle such operations given that power bi has a limitation of 1gb per report.

How we should expose or best approach for curated data to power bi example-dedicated pool, serverless pool or external views etc

Thanks

Answer 1

Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to upvote and if the reply is helpful--

Answer 2

In my case, after quite a bit of trial and error, I found that the most effective approach was to split the database tables across multiple databases (four in my situation). The larger ones, which we only refresh once a month, were separated from the relatively smaller ones that we refresh on a daily basis. What I did was create separate panels containing just the large data and then linked my main panel to them through the Data Pool, in Direct Query mode, with my data stored in my own Workspace of Power BI. This move significantly reduced the size of my panel from 0.99GB to a mere 5MB.

To give you an idea, the largest database by itself was around 450MB, with a compression ratio (for CSV data) of 7:1. Limited to 1Gb, this essentially allowed us to nearly double the available data while taking up less space. Admittedly, it requires a bit more effort to keep everything up-to-date, but considering the budget constraints, I believe this approach offers the optimal solution.