PBI Features reported by user group, can someone provide update on PBRS items

[mchoure]

Dear Members, I am creating chart for PBRS vs PBI online comparision, can someone guide me if there are any links available for PBRS items?

S.No.	Issue	Features/issues	PBRS	PBI online
1	Dataset size limit	Datasets cannot be larger than 2GB		1 gb Limit https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-in-power-bi#d...
2	Row limit	DIrectQuery is limited to 1 million rows		This limitation is by Microsoft https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
3	Column limit	Max number of columns is 16,000		https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data#considerations-and-limitatio...
4	Composite Model	Composite Model not a feature on server	Feature not available in PBRS	It is available in PBI online
5	Tagging of data/Write back	Data tagging/write back is not available on server		Dataset tagging (C1,…C4)) is available in PBI online
6	Export to Excel	Excel export has limited rows/features		https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...
7	Free text search/user input	No free text search or user input features available		Some custom Visual are available Power BI Custom Visual – Text Filter From <https://blog.pragmaticworks.com/power-bi-custom-visuals-text-filter>

[Icey · Accepted solution]

Hi @mchoure ,

Please check:

S.No.	Issue	Features/issues	PBRS	PBI online
1	Dataset size limit	Datasets cannot be larger than 2GB	up to 2 GB https://docs.microsoft.com/en-us/power-bi/report-server/whats-new#large-file-uploaddownload	1 gb Limit https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-in-power-bi#d...
2	Row limit	DIrectQuery is limited to 1 million rows		This limitation is by Microsoft https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
3	Column limit	Max number of columns is 16,000		https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data#considerations-and-limitatio...
4	Composite Model	Composite Model not a feature on server	Feature not available in PBRS	It is available in PBI online
5	Tagging of data/Write back	Data tagging/write back is not available on server	Power Apps visual is not supported in PBRS. https://shabnamwatson.wordpress.com/2020/02/21/using-power-apps-in-power-bi-reports-enabling-writeba...	Dataset tagging (C1,…C4)) is available in PBI online
6	Export to Excel	Excel export has limited rows/features	You can export directly to the Excel .xlsx format, and the export limit is 150 K rows. https://docs.microsoft.com/en-us/power-bi/report-server/whats-new#export-to-excel-from-power-bi-repo...	https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...
7	Free text search/user input	No free text search or user input features available	Text filter can also works in PBRS.	Some custom Visual are available Power BI Custom Visual – Text Filter From <https://blog.pragmaticworks.com/power-bi-custom-visuals-text-filter>

---

In addition, here is more details: Comparing Power BI Report Server and the Power BI service.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.