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.
Community SupportHi pawlowski6132 ，
Sorry, I am not familiar with the feature. But I have found an idea:https://ideas.powerbi.com/ideas/idea/?ideaid=3f3c572b-2f0a-4f77-9381-35a59b4cc1cc
We're not planning to make this feature available in Power BI Report Server. We are looking at making available an API to allow you to change the data source programatically, however, to make movement between servers easier.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Solution Sagepawlowski6132 / CST,
below idea has been closed so unable to post there but you may use a workaround if that suits you!
https://ideas.powerbi.com/ideas/idea/?ideaid=3f3c572b-2f0a-4f77-9381-35a59b4cc1cc
Instead of a shared source please parameterize your connection string to source (eg SSAS) with 2 report parameters(hidden params) and these params should be hidden and populated with another dataset on your report which access a table in your source with these values. that table can be changed as per environment (Dev/QA/Prod) so that your report automatically accesses the environment without you having to change the connection on every paginated that you will develop!
<ConnectString>="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!CubeDatabaseName.Value & ";Disable Prefetch Facts=True;ReturnCellProperties=True;Integrated Security=SSPI"</ConnectString>