Forum Discussion

niyati_61's avatar
niyati_61
Helper III
2 years ago

Hello d_gosbell  and lbendlin ,

 

Thanks for your response!

 

A follow-up question, you mentioned - 'if you have licensed SQL Server Enterprise with Sofware Assurance to get your PBIRS license then you are free to put any other databases you like on that server'.

 

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?).

 

Also, lbendlin , can you please explain what this below means?

 

'Power BI has no memory. You must store your data in a SQL Server database, but a different one than what comes with the RS install.'

 

What do you mean Power BI has no memory? Where is it's relevant backend data stored then?

 

As d_gosbell mentioned, in this same SQL Server (the one linked with PBIRS) - I can create another database within it right?

 

Thank you!

 
d_gosbell's avatar
d_gosbell
Super User
2 years ago
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.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.

    • josef78's avatar
      josef78
      Memorable Member
      2 years ago

      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.