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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
o59393
Post Prodigy
Post Prodigy

Power bi get data from databases

hi all

 

I am doing power bi models directly connected to the CSV or folders from my computer, the problem is that I am the only one able to manipulate the model and raw data since the source is the address of my desktop.

 

source.PNG

 

My concern is that I will change a role in my company in a few months, therefore the new person wont be able to manipulate the files since everything is from my source.

 

The question is, what are the best options to maintin the power bi models created in a way that is easy to transfer the responsibility from one person to another. 

 

Any material to learn will be appreciated.

 

Thank you.

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

There is an option Data Source Setting or Edit Data Source setting in Model View under home tab. In New Ribbon it is under Transform data.

The new user can go ahead and change the sources. It will pick up date from new sources.

 

Screenshot 2020-01-04 07.32.41.png

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

There is an option Data Source Setting or Edit Data Source setting in Model View under home tab. In New Ribbon it is under Transform data.

The new user can go ahead and change the sources. It will pick up date from new sources.

 

Screenshot 2020-01-04 07.32.41.png

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak 

 

What do you think of Azure? Have you used it or recommend it?

 

Thanks!

I have not tested that. But if you access the central system it should work. Like when we use the database, the same file work when we change the system.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Ok thanks, will do that!

 

One final question, is it possible to change the source from a specific CSV to a folder?

 

Thanks!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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