Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
What is this?
Less
More

Memberships

Learn Microsoft Fabric

Public ā€¢ 5.8k ā€¢ Free

2 contributions to Learn Microsoft Fabric
Error with Fabric Notebook
Error while working on Fabric notebook - "Cannot connect to collaboration server. File is locked for edits and saves. Try reconnecting. If that doesn't work you can continue editing without reconnecting. Making edits without reconnecting may cause conflicts." Please anyone can share some insights . Could be basic issue but unable to figure out
0
1
New comment Aug 1
What architecture to follow for Data Analysis in Fabric?
Hi @Will Needham I have started working on Fabric and basically my need is to build BI reports/dashboards. Until fabric was available was using Power BI connecting to data sources and building the reports. Did not have a Data warehouse as of now as we stared using Power BI also 3 month ago. Instead of having an on-prem DW was considering to setup everything in Fabric. So this is where i am. I am considering to understand what my fundamental architecture should be with current needs and upcoming needs in future. We don't have on-prem data sources from where i need to get data and build reports that i have on my way. Basically majority of my reports will be single or multiple data sources like 1) AS400/ SQL/Excel files/Oracle DB 2) Information from online web portal from where data can be exported to excel or can connect the portals/ Cloud application like Jira cloud/ Cloud HRMS solutions. SO for the above Power BI report needs what is the appropriate architecture i should consider. I do not have Python expertise but have team that can help but good T-SQL exposure. Mainly i want to know how my architecture should be built so my current needs and future needs can be taken care without major changes. I have read about Medallion Architecture but not sure how i should define considering above needs
3
13
New comment May 3
0 likes ā€¢ May 1
Please share your inputs.
0 likes ā€¢ May 3
@Medard Sery Yes what you mentioned makes sense to me and right now this is a reference i have created and for sure this will change. My main goal is to have a staging / raw data store and then work on the raw data and move to my main store - DW from where i can use the data for my reports. Datamarts/directlake is options store idea if needed for very specific needs where i need to combine data from different datasets or tables. Let me know if this thought process makes sense.
1-2 of 2
Ashwin PAnchal
1
1point to level up
@ashwin-panchal-8306
System Analyst

Active 122d ago
Joined Apr 23, 2024
powered by