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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

 

 

 

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

 

 

 

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.

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors