Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 way to adjust what data source my report pulls from based on some parameters when the report is opened, either on app.powerbi or on publish to web?
Thanks
Jethin
Solved! Go to Solution.
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
Hi @jgowda,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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
Hi @jgowda,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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 way to adjust what data source my report pulls from based on some parameters when the report is opened, either on app.powerbi or on publish to web?
Thanks
Jethin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |