Forum Discussion
Help needed with Microsoft Fabric
Hello everyone,
I am currently learning Microsoft Fabric and working on its setup and features. I am facing some issues related to workspace setup, publishing, and data connectivity. If anyone can share best practices or common mistakes to avoid, it would be very helpful.
Thank you for your support.
Hi kunal9211pandey perhaps you could get more specific about the type of issues you're facing, Fabric is a huge platform, hence, the potential of things not going corerctly or perhaps, not configured to do what you expect 😉
So for the time being, I'll share a few best practices or common mistakes to avoid that can save you a lot of pain...
#1. First, set up separate workspaces (DEV/TEST/PROD) and assign access via Entra ID groups, not individuals.
#2. Design around OneLake and Lakehouse-first, so data is landed once and reused across notebooks, pipelines, SQL, and Power BI.
#3. Use clear naming conventions early to keep things manageable.
#4. For publishing, use deployment pipelines, parameterize environment-specific values, and be careful when rebinding Power BI reports to semantic models after promotion.
#5. Do not hardcoded paths and/or credentials
#6. Prefer Fabric-native connectors and OneLake shortcuts instead of copying data.
#7. Finally, watch capacity usage and scheduling
#8. Avoid one giant workspace for everything or giving too many users Admin rights for convinience.
#9. Understand and use Shortcuts instead of copying data whenever possible.
#10. For data ingestion, use the medallion architecture
I can go on and on and on for this topic, and I'm pretty sure other people in this forum will share additional points 😉 , so, start with this ones and hope they help on your journey and if you can describe more on spefici issues your're facing, more than willing to assits. All the best, remember to give a thumbs up 😉
Hello kunal9211pandey
I found the following 2-part article pretty good summary of Microsoft Fabric features and it's best practices.
Part 1:
(6) Lessons learned and best practices implementing Microsoft Fabric (part 1) | LinkedIn
Part 2:
(6) Lessons learned and best practices implementing Microsoft Fabric (part 2) | LinkedIn
2 Replies
- svenchio
Super User
Hi kunal9211pandey perhaps you could get more specific about the type of issues you're facing, Fabric is a huge platform, hence, the potential of things not going corerctly or perhaps, not configured to do what you expect 😉
So for the time being, I'll share a few best practices or common mistakes to avoid that can save you a lot of pain...
#1. First, set up separate workspaces (DEV/TEST/PROD) and assign access via Entra ID groups, not individuals.
#2. Design around OneLake and Lakehouse-first, so data is landed once and reused across notebooks, pipelines, SQL, and Power BI.
#3. Use clear naming conventions early to keep things manageable.
#4. For publishing, use deployment pipelines, parameterize environment-specific values, and be careful when rebinding Power BI reports to semantic models after promotion.
#5. Do not hardcoded paths and/or credentials
#6. Prefer Fabric-native connectors and OneLake shortcuts instead of copying data.
#7. Finally, watch capacity usage and scheduling
#8. Avoid one giant workspace for everything or giving too many users Admin rights for convinience.
#9. Understand and use Shortcuts instead of copying data whenever possible.
#10. For data ingestion, use the medallion architecture
I can go on and on and on for this topic, and I'm pretty sure other people in this forum will share additional points 😉 , so, start with this ones and hope they help on your journey and if you can describe more on spefici issues your're facing, more than willing to assits. All the best, remember to give a thumbs up 😉
- deborshi_nag
Super User
Hello kunal9211pandey
I found the following 2-part article pretty good summary of Microsoft Fabric features and it's best practices.
Part 1:
(6) Lessons learned and best practices implementing Microsoft Fabric (part 1) | LinkedIn
Part 2:
(6) Lessons learned and best practices implementing Microsoft Fabric (part 2) | LinkedIn