Forum Discussion
Data Source Created. How to use with Paginated Report
So, I have successfully created a Data Source in Power BI Report Server. I'd like to use that when authoring a Paginated Report BUT, that option isn't available in the list of available Data Sources from Paginated Report or, so it seems.
What am I missing?
thanx in advance,
Joe
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.
17 Replies
Hi 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
So, 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?
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 - 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.
Ahhhhh. Yes. It all makes sense now. Or, at the very least, I understand the issue. Wow, to be honest, for a dummy like me, this can be hard to follow. Or, unintuitive at best.
Anywho, thanx so much for clarity.
