Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jabbott
New Member

PowerBI Templates

When I export a PowerBI report to a template I understand that it removes the data that was saved with the report, but how do I remove the data source as well? We are preparing templates to be distributed to customers and we don't want our internal data source to show when they first open the template. I would have expected the template to be void of any data or connection info.

1 ACCEPTED SOLUTION
hugoberry
Responsive Resident
Responsive Resident

Try adding the connection string as a parameter in your workbook. And in Power Query queries reference this parameter for the connection.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @jabbott,

 

As @hugoberry suggested, you can use query Parameter to define the data source connection string. For example, if you want to get data from the SQL Server database, you can create two parameters Server and Database. Then export to .pbit files. When open the .pbit files by client users, it will prompt the user to enter values for parameters Server and Database. For more information about create query parameters, please refer to links below:

Deep Dive into Query Parameters and Power BI Templates

Power BI Desktop Query Parameters, Part 1

 

a3.PNGa2.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Is it possible do you it for Excel spreadsheet as well.

I would like to create a report then a template and give it to different users.

They will just have to "import"/"connect" their own excel file to view thei data into the report.

 

Thanks for your help

Pierre

hugoberry
Responsive Resident
Responsive Resident

Try adding the connection string as a parameter in your workbook. And in Power Query queries reference this parameter for the connection.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.