Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I'm a sysadmin and my organisation is looking more into powerbi where it can. One particular situation is we have an in-house time recording app that is all on premise with a sql db, so we've got a data gateway set up for it and thats all fine, but now the devs have just told me that they also use an excel file for extra information which currently sits in one of the devs OneDrive.
I'm trying to explore any pitfalls or implement some best practices now to future proof the company, and overall gain a better understanding of this.
The few ways I can see this going are:
My main concern has been what happens if its on the users onedrive and they change their domain password. I imagine it needs to be republished?
Any guidance or resources on this are greatly appreciated.
Solved! Go to Solution.
You have a close idea, but might be missing a key detail.
When you create your data source, in this case a place on sharepoint, you simply give access to the service. This will be the same system that your SSO relies on.
When you develop in Power BI, when you connect to the data source you will have the option of what credentials to use. By default it will show you your SSO account, but you have the option of choosing another account. Thats the point in time where you have your developer log in with the service account. The sign in here is a data source credentials sign in, rather than account you have signed into Power BI with.
This will keep your projects developer independant.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |