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

Memberships

Learn Microsoft Fabric

12.7k members • Free

4 contributions to Learn Microsoft Fabric
Fabric semantic model(default) not displaying tables into Powerbi
I am not able to use the default model to show tables in the Powerbi. Alternative of this was to go into the lakehouse and then click on "New semantic model", create one and then open in data model do the joins, save it and after this, use this model in Powerbi. Any idea why we cannot use default model?
0 likes • Jun 13
[attachment]
0 likes • Jun 13
[attachment]
Suggest best way to connect SharePoint to Fabric ??
The SharePoint site contains folder like structure say year/month/date in that (list of files) and files are incrementally added every day so how to load the data in same format in Fabric Option 1: By creating a connection( with tenant details) using copy data can able to load only the schema of the files in the lakehouse not the physical tables Option 2: Using the dataflow gen2 failed to run the query as the data for the one month is more then 5GB Please suggest an optimise way to connect SharePoint of fabric
0 likes • Jun 8
We had similar requirements where in data was in SharePoint but in same folder. Users will add files or update files in same folder. If the files are not that big then below shall work as it will move all files. I have used logic apps "When a file is created or modified (properties only)" to my source files to Azure storage account. Works fine so far. For this trigger I have also set "Split on" property to off because I noticed when I had added multiple files added/updated, the pipeline fail complaining it is already in use. 2nd step is to add "List folder" and pass site address and file identifier. 3rd step is to add "Get file content" and pass site address, file identifier (dynamic value = "id"). At this point a for each will be added automatically. 4th step is to add "Create blob (V2) and pass storage account , source folder path, blob name (dynamic value = display name) and blob content (dynamic value = file content) This workflow can be scheduled as per need and will do the job of moving files.
Share point to Fabric
Hi All, I need some guidance as I am designing this first time in Fabric. We have several data sources in SharePoint (Excel files) that need to be migrated to Fabric. This data will then be exposed to Power BI for data quality checks. Once we identify the data that requires fixing, the Data Analyst (DA) or Subject Matter Expert (SME) will update the files in SharePoint, which will trigger the workflow again. Additionally, when the data is in Fabric, we need to maintain its history and versioning so that we can compare new data with the old data at a later time. Q1 = I'm unsure about the best approach for implementing this solution in Fabric. Should I use DLT, or do I need to set up a proper SQL database? Q2 = Can I bring data from sharepoint directly to Fabric or should I first bring it to the Storage Account then to Fabric one lake?
0 likes • May 16
Thank you @Will Needham for your response. I need to bring data in Fabric but also maintain the history of the changes in the data. What approach shall I plan?
Sign up for FREE DP-700 LIVE Training with Microsoft
Microsoft Reactor are hosting another series of FREE DP-700 live sessions - this time I'll be co-presenting a session, and moderating another, alongside some awesome people! 🔗👍 Sign up for the series here --> https://aka.ms/dp700/live Session details: Apr 30 2025 - DP-700: Get started with data engineering on Microsoft Fabric - Speakers: Charley Hanania, Johan Ludvig Brattås, Yarden Dor May 01 2025 - DP-700: Ingest and manage data in Fabric with data factory and notebooks - Speakers: Frank Geisler, Matthias Falland May 07 2025 - DP-700: Implement real-time intelligence in Microsoft Fabric - Speakers: Ginger Grant, Heidi Hasting May 08 2025 - DP-700: Data warehousing in Microsoft Fabric - Speakers: Brian Bønk, Mahmut Olcay Çelik May 14 2025 - DP-700: The Microsoft Fabric environment - CI/CD, monitoring, and security - Speakers: Kevin Chant, Lee Benjamin May 15 2025 - DP-700: Microsoft Fabric administration and governance - Speakers: Ásgeir Gunnarsson, Will Needham May 21 2025 - Prepare for exam day and open Q&A - Speakers: Aleksi Partanen, Reitse Eskens
Sign up for FREE DP-700 LIVE Training with Microsoft
1 like • Apr 26
Singed Up
1-4 of 4
Sachin Satkalmi
1
3points to level up
@sachin-satkalmi-9858
Development Engineer

Active 9d ago
Joined Feb 7, 2025
Powered by