Forum Discussion
Power BI Report Server Data and SQL Server
niyati_61 wrote:
So, do you mean on my current SQL Server (With which PBIRS is linked) - in that same SQL Server itself, I can create another database, then create a table, and store data within the table (Which would resolve my storing data issue?).
Yes, this is correct.
Power BI is a reporting tool. It takes someone else's data and visualizes it. Power BI is not a primary data store , any data it has can be erased and overwritten with no easy mechanism to get it back.
This is correct for data stored in Power BI semantics models (which are stored as BLOB image in ReportServer database on SQL Server), these models is not for primary data. But you can store primary data on another DB on same SQL Server.
If PBI Report Server is licenced through SQL Server EE SA licence, you need to have least one MSSQL server (covered by same licence or another one licence), and on this MSSQL server you can have more independent databases (not only ReportServer DB), for any other purposes, including storing primary data for reporting, or for any else purpose (little different situation is if PBI RS is licenced through PBI Premium licence, where is licence some restriction).
BUT...
For simple small scenarios it is ok, but for large production scenarios it is not good practice, is better to install separate MSSQL server for primary data, separated for MSSQL with ReportServer DB, due very specific workload on this server.
