Forum Discussion
Helper VData Source Created. How to use with Paginated Report
pawlowski6132 - I see the issue now. Just like there are 2 versions of Power BI Desktop, there are also 2 versions of Report Builder and you are using the version built for powerbi.com not the on-prem version. v-deddai1-msft is still confusing the issue between Power BI Desktop and Report Builder.
If you open the home page of your Report Server portal, in the top right corner is a downloads icon which has a menu that will take you to the correct version of both Power BI Desktop and Report Builder to use with your version of Power BI Report Server.
Or if you are on the Jan 2021 release you can get the latest version of the on-prem Report Builder from the following link
https://www.microsoft.com/en-us/download/details.aspx?id=53613
When you use this version you will see the option for using shared datasets as in the screenshots I posted earlier.
Solution Sageyes, you would not be able to use shared data sources in Power BI ReportBuilder, they are there to support SSRS RDL reports. One workaround in to create your rdl in SSRS using SSDT/Report Builder and then once you have the shared DS connected you can open it up in Power BI report builder to work further. There is no fundamental difference between Power BI rdl and SSRS rdl as long as you do not wish to use Power BI Report builder Live connections with Power BI datasets or you are building them for service.
If you are hosting on Power BI report server, please go ahead and use SSDT to builde rdl and then switch that over to Power BI report builder or build it completely from SSDT
Helper Vthanx much for a good alternate solution, much appreciated.