Power BI report deployment for end user

0
votes

I have designed a power bi report for a client using data set as his SQL Server database backup in my local system, and publish it on his provided power bi service account, now how do i connect this publish report with my client's local SQL server database? In other words how my client be able to connect his local system's SQL database with this report?

1
powerbipowerbi-datasourcepower-bi-report-server
Just change the source of the table(s) in the query editor. - Alexis Olson
is there any option to change data source in Power BI service? - TAIMOOR BUTT
You could probably do that with a dataflow. - Alexis Olson

1 Answers

0
votes

You can use parameterized connection where you can store your local database access and client database access details, by using:

enter image description here