Forum Discussion

jgowda's avatar
jgowda
New Member
8 years ago
Solved

Changing Data Source

It is possible to adjust the data source of a power BI report from any level higher than Power BI Desktop? Can I change the source from when a report is published or published to web? Is there any wa...
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi jgowda,

     

    Based on my test, We cannot change data source of a report from Power BI service. Here we can use parameter to change data source.

    Then we can get data using the Parameter that we created. In power query we can get different data of different data sources by changing the Current value.For more details, please check the online document.

     

     

    Here is the M code for your reference.

    let

        Source = Sql.Databases(Parameter1),

        Power_BI_Test = Source{[Name="databasename"]}[Data],

        dbo_Financial_1 = databasename {[Schema="dbo",Item="Financial_1"]}[Data]

    in

        dbo_Financial_1

     

    Regards,

    Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi jgowda,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi jgowda,

 

Based on my test, We cannot change data source of a report from Power BI service. Here we can use parameter to change data source.

Then we can get data using the Parameter that we created. In power query we can get different data of different data sources by changing the Current value.For more details, please check the online document.

 

 

Here is the M code for your reference.

let

    Source = Sql.Databases(Parameter1),

    Power_BI_Test = Source{[Name="databasename"]}[Data],

    dbo_Financial_1 = databasename {[Schema="dbo",Item="Financial_1"]}[Data]

in

    dbo_Financial_1

 

Regards,

Frank