Forum Discussion
Power BI shared connection library
Hello Anonymous
the login data is stored in the profile. So there is only the need to maintain it once.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello Anonymous
Power Query - alias M - is a functional programming language. Therefore there are available for a lot of data sources different functions, that require parameters, like server or whatever. For some data sources is possible to maintain queries in SQL/MDX/DAX and other additional information. This all you can hardcode. However, IDs or passwords can not be hardcoded. They have to be set up by the different user, refreshing the query.
Hope now is clearer
Jimmy
Thanks,
think I'm getting the idea. I asume taht if I create a report against an Oracle Db and share the Power BI file, when they chose to refresh the data it will prompt them for username.pwd. Will that be saved somewhere or will it always prompt on each refresh ?
Also reading up about PBID files ...
Appreciate this.
Hello Anonymous
the login data is stored in the profile. So there is only the need to maintain it once.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy