There should be an option to not cache credentials for data sources from connections with Power BI. This is a security issue and does not go well with customers.
oz_mike
6 years agoNew Member
Hi caching the credentials has a nasty side effect you may not be aware of. If the site you are on has a change password policy every few months etc..and n lock attempts, once the user changes the password and they open the pbix file it can lock them out as tries to log in multiple times. So the admin guys unlock the file and again , and the user opens the file it lock them out again . So . The work around is for the user to know to clear credentials before they open the file (not obvious) . The power bi file should only attempt once to log on if it fails stop!? or have a setting to force the user to log in each time. ie an option do not store credentials - could be per table level or global. se this link http://community.powerbi.com/t5/Desktop/Power-bi-locks-user-out-of-database-if-password-has-changed/m-p/185765#M81648
Recent ideas
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠ enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande10 hours agoNew MemberNew180Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes18 hours agoNew MemberNeed Clarification198Views3likes1Comment