Forum Discussion

jesusrincon's avatar
jesusrincon
Frequent Visitor
3 years ago
Solved

Connect to Power Bi dataset from report server

Hi, this a fair recent issue I haven't been able to work around. There's a Power BI dataset I need to connect to and create reports that need to be published into a Report server. So far I can connec...
data-sources
report-server
  • d_gosbell's avatar
    d_gosbell
    3 years ago
    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's avatar
jesusrincon
Frequent Visitor
3 years ago

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.

Shahfaisal's avatar
Shahfaisal
Solution Sage
3 years ago
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)