Forum Discussion
Helper VHow to create a connection to a database with integrated credentials and then use it in PBI Desktop?
Hi Fern_21,
Users can ONLY access the tables you include in the Dataflow.
When users connect to your Dataflow in Power BI Desktop, they can:
Import only the entities (tables) inside the Dataflow
Build their own model on top of those tables
Combine with other local files (Excel, CSV, etc.) if they want
Super UserHi Fern_21,
Not possible while creating a connection but you can achieve is by either created a shared dataset or by creating a semantic model and sharing the access to users.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!