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.