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 ,
Are you trying to connect to data source in Power BI Report Server by paginated report? It doesn't support to it. You can refer to https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources for supported data source.
You can connect to dataset from power bi service. Please refer to https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets
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
Helper VSo, if we can't connect to a data source in Report Server via Paginated report or PBI Desktop, what is the use case for using a data source in Report Server?
- v-deddai1-msft
Hi pawlowski6132 ,
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
- pawlowski6132
Thanx for taking the time to reply. I should have been more pointed, what if any is the use case in the Power Platform ecosytem for datasource in report server? (I'm beginning to get the feeling that the answer is, "Absolutely nothing.")
I looked at the article. I have no idea what Report Builder is.
thanx again.
- d_gosbell
Super User
There seems to be a lot of confusion on this thread between paginated reports and pbix reports.
On Power BI Report Server data sources can ONLY be used by paginated reports and you have 3 options for connecting a report to a shared data set.
1. After deploying a report you can click on the "..." menu for that report, then click on "Manage", then in the Data Sources tab you can change any of your embedded connections to use one of the shared connections on the server. This is handy if you have an existing shared connection with the connectionstring/username/password already saved.
2. From Report Builder you can choose the option to use a Shared connection. Then you click browse, the first time you will need to enter "http://<servername>/reportserver" in the name area and click Open and you should then see the folders on your Report Server and you can navigate to and select one of the Data Sources you have already created.
3. If you are using SSDT to author your reports you can created both the shared data sources and your reports within your report project, then when you deploy that project both the reports and the data sources in that project will get deployed.