Forum Discussion
Connect to Power Bi dataset from report server
jesusrincon wrote:
So I still will need to deploy the data sources? I'm interested mostly on the relationships / measures / calculated columns. I can deploy the raw PBIX from our analysts, as I can configure the connection strings for the databases, but in case a measure or any calculation requires any changes, they will need to make changes to each of the reports that are connected to this dataset. Is there no other way around for this? I'm mostly interested on the tabular model behind the PBI file.
If you deploy a report to the service based on a dataset on the service then any fixes you make to measures will flow through automatically. If your report builders add their own measures to their reports they would need to fix those themselves.
The only way to achieve something similar on-prem is to install a SQL Server Analysis Services instances and have your developers deploy any shared data models to that. But that is more of a BI pro scenario as you cannot use Power BI Desktop to deploy to SSAS, you need to use something like Visual Studio or Tabular Editor.
jesusrincon wrote:
I'm not really sure where the problem is, and I feel this is something that is supported right now. The main reason for this is to allow us to publish massively reports on our report server from a data source created by analysts on the Power BI Online Service
No, this is not supported. This list of supported data sources for Report Server is documented here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn and data sets in the Power BI service are not supported on Report Server.
If you want to publish reports like this where the dataset is on the service you should publish the reports to the service also.
So I still will need to deploy the data sources? I'm interested mostly on the relationships / measures / calculated columns. I can deploy the raw PBIX from our analysts, as I can configure the connection strings for the databases, but in case a measure or any calculation requires any changes, they will need to make changes to each of the reports that are connected to this dataset. Is there no other way around for this? I'm mostly interested on the tabular model behind the PBI file.
jesusrincon wrote:So I still will need to deploy the data sources? I'm interested mostly on the relationships / measures / calculated columns. I can deploy the raw PBIX from our analysts, as I can configure the connection strings for the databases, but in case a measure or any calculation requires any changes, they will need to make changes to each of the reports that are connected to this dataset. Is there no other way around for this? I'm mostly interested on the tabular model behind the PBI file.
The dataset you intend to source data form sholuld be in Power BI Service (not on Power BI Report Server). And once you consume the data set in Power BI desktop, you can only publish it to Power BI Service (not Report Server)
jesusrincon wrote:
So I still will need to deploy the data sources? I'm interested mostly on the relationships / measures / calculated columns. I can deploy the raw PBIX from our analysts, as I can configure the connection strings for the databases, but in case a measure or any calculation requires any changes, they will need to make changes to each of the reports that are connected to this dataset. Is there no other way around for this? I'm mostly interested on the tabular model behind the PBI file.
If you deploy a report to the service based on a dataset on the service then any fixes you make to measures will flow through automatically. If your report builders add their own measures to their reports they would need to fix those themselves.
The only way to achieve something similar on-prem is to install a SQL Server Analysis Services instances and have your developers deploy any shared data models to that. But that is more of a BI pro scenario as you cannot use Power BI Desktop to deploy to SSAS, you need to use something like Visual Studio or Tabular Editor.
