PB implementation with SQL serer standard edition

[bobjSrikanth]

Hi There,

Power BI implementation can work with SQL server standard edition? If yes what is the different from 

[d_gosbell · Accepted solution]

---

@bobjSrikanth wrote:

Thank you so much for your reply. Yes I was asking about the PBI RS.

If we choose SQL Server Enterprise Edition with Software Assurance, do we need to go for Premium/Pro Licence or does it included in SQL Server Enterprise Edition with Software Assurance?

---

So if you license PBIRS through SQL Server Enterprise Edition with SA you do not need to purchase any Premium capacity. But any authors that want to publish pbix reports to PBIRS will require a Power BI Desktop Pro license (but users that just want to view reports do not require any other license). 

[bobjSrikanth]

Thanks a lot for your support.

I am trying to refresh a report(import SQL server DB) in PBI desktop tool for RS, the report is running and running and never executed and thrown an error. as shown in the image.

we have 8GB RAM and 1TD HDD.

Thank you in advance

[v-janeyg-msft · Accepted solution]

Hi, @bobjSrikanth 

The error message prompts you that there is insufficient memory, so your data should be quite large.

Do you try to use DQ mode or import less data, or you can filter data in pq first to avoid excess data imported to report?

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[d_gosbell]

Note that this may not just be an issue with the raw data size. You should be able to load hundreds of millions of rows into Power BI Desktop before you come close to data volume issues. This could also be caused by issues in one or more of your queries that are blocking query folding and causing Power BI to try and load the entire dataset into memory prior to compression. By default Power BI normally compresses data in 1 million row segments and writes those out progressively.

[bobjSrikanth]

Thank you so much for your reply. Yes I was asking about the PBI RS.

If we choose SQL Server Enterprise Edition with Software Assurance, do we need to go for Premium/Pro Licence or does it included in SQL Server Enterprise Edition with Software Assurance?

Thank you in advance.

[d_gosbell · Accepted solution]

---

@bobjSrikanth wrote:

Thank you so much for your reply. Yes I was asking about the PBI RS.

If we choose SQL Server Enterprise Edition with Software Assurance, do we need to go for Premium/Pro Licence or does it included in SQL Server Enterprise Edition with Software Assurance?

---

So if you license PBIRS through SQL Server Enterprise Edition with SA you do not need to purchase any Premium capacity. But any authors that want to publish pbix reports to PBIRS will require a Power BI Desktop Pro license (but users that just want to view reports do not require any other license). 

[d_gosbell]

From a functionality perspective there is nothing in Power BI that requires the enterprise edition. Everything should work fine with the Standard Edition.

If you are talking about Power BI Report Server specifically then it depends on how you want to license it. see here https://docs.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server for the 2 different ways of acquiring a license for Power BI Report Server