Forum Discussion
Power BI Service to Report Server on premise solution
Yes, if you are using August'22 PBI Desktop, best option is wait for September'22 PBI Desktop RS.
Direct Query for SAP BW is also supported in PBI Desktop RS and PBI RS.
Generaly, Direct Query mode has many limitation, on any source, and in PBI Premium same as PBI RS.
Main difference between PBI Premium and PBI RS (from model design perspective) is composite models. Some limitations of PBI RS can be easily reworked (like M:M relations), but some limitations hasn't alternative, especially composite models which combining direct-query and import-mode in single report.
For save some time, I recommends reworks some single simple report using May'22 PBI Desktop RS. If you don't run into obstacles (unresolvable), then wait for September'22 for all other reports, to check easiest way: open pbix in PBI Destkop RS and save to PBI RS.
Memorable MemberIt will work, you can open your pbix file, developed in Power BI Desktop (optimized for cloud), also in Power BI Desktop optimized for Report Server, and save as to on-premise Power BI Report Server.
But there are two limitations.
You cannot open pbix file in older version of PBI Desktop. And you cannot open file contains features not supported in RS (like composite models).
Approach is easy, use up to may 2022 version, or wait for sep 2022 RS version. First remove all unsupported features in RS.
Thanks for the response.
The desktop tool for the current set of reports is of version August 2022 and for the report server the latest version is May 2022. In this case we are getting the version error while opening the pbix file. And I believe this is the limitation number 1 which you mentioned above, right ?
And also to add, we are using Direct Query via SAP BW for the current reports which already has a long list of limitations with Power BI desktop.
Any other option apart from the below ?
1. Wait for the Sept 2022 RS release
2. Re-develop the reports on Power BI Desktop RS
- josef78
Yes, if you are using August'22 PBI Desktop, best option is wait for September'22 PBI Desktop RS.
Direct Query for SAP BW is also supported in PBI Desktop RS and PBI RS.
Generaly, Direct Query mode has many limitation, on any source, and in PBI Premium same as PBI RS.
Main difference between PBI Premium and PBI RS (from model design perspective) is composite models. Some limitations of PBI RS can be easily reworked (like M:M relations), but some limitations hasn't alternative, especially composite models which combining direct-query and import-mode in single report.
For save some time, I recommends reworks some single simple report using May'22 PBI Desktop RS. If you don't run into obstacles (unresolvable), then wait for September'22 for all other reports, to check easiest way: open pbix in PBI Destkop RS and save to PBI RS.