Forum Discussion

dbadmin's avatar
dbadmin
Icon for Advocate V rankAdvocate V
10 years ago

Power BI's In-memory store - for clarification purposes... how does it work exactly?

I am part of our company's R&D, also the report author for a different part of the company.    I have been researching how to create a reporting database instead of trying to run reports through ou...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

As long as a nightly snapshot of the reporting data is all you need.  If you need more current data, you would still have to take the hit against production data if you need to refresh the report during the day.

 

At my previous job, we ran the majority of the web site off of reporting servers.  The four reporting servers were using log shipping from production and had a lag of 1 to 5 minutes. 

 

Simplified for your question:

1.  Create your Power BI report connected to your production database.

2.  Upload Power BI report to the Portal

3.  Use the Enterprise gateway to refresh the reports (datasets) nightly (currently a big guess if will refresh on time or if at all with the current version of the gateway)

4.  Use the Power BI portal during the day.

 

Power BI accounts have a 10gb limit

Power BI reports currently have a 250 mb size limit