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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
lekkerbek
Helper IV
Helper IV

Change datasource - removes old data or keeps in cache?

Hi,

 

I have a Power BI file that I would like to re-use for another customer. The underlying model is exactly the same. Just the data is obviously different.

 

Can I simply copy the model and change the data source settings to the new customer? Or will it keep the old data in cache which can be retrieved by someone clever (so client Y can seen data of client X because he/she was able to retrieve it)? 

1 ACCEPTED SOLUTION

Hi @lekkerbek,

I think you can parameterize your report and save it as a template.
Then you can share this with other users, they can change the data source connection string to generate their own report with raw report structures.

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power B...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@lekkerbek , change the source connection details and refresh

Using edit connection or power query

 

How to Change Connection Details: https://youtu.be/59PUFuuCrbY

 

 

Another one save as template and try

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thank you for your answer. However my question was related to something else. I know how to change the settings, but wanted to check if there is no link whatsoever to the old data if I update the settings.

Hi @lekkerbek,

I think you can parameterize your report and save it as a template.
Then you can share this with other users, they can change the data source connection string to generate their own report with raw report structures.

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power B...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thank you. I will try this solution.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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