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

Memberships

Prosperity Lab

Private • 16.8k • Free

Learn Microsoft Fabric

Public • 5.6k • Free

9 contributions to Learn Microsoft Fabric
Spliting capacities per environments or zones
Hi falks, I am planing to create a capacity for dev/qa environemnts and a second one for production where we plan to locate the gold zone for semantic model and powerbi consumption. The question is, should be booth capacities of the same size? Should be the reporting capacity bigger than the capacity for data engineers?
2
4
New comment Oct 13
1 like • Oct 11
Maybe what I'm about to say doesn't make much sense, but isn't there a possibility of Autoscale capacity?
Spark in Microsoft Fabric... some doubts
I'm taking the 30-day Spark course, but I still have a few doubts, which are as follows: DataFrame filtering To read the contents of a table into a dataframe we can write: df = spark.sql( “SELECT * FROM SparkSetember.propertysales LIMIT 1000” Subsequently, we can, for example, Filter the table with the function: df.filter(df.City.startswith(“L”)).show() My question is this: Why don't we do it straight away: df = spark.sql( “SELECT * FROM SparkSetember.propertysales WHERE Citi Like ‘L%’ ”
2
4
New comment Oct 13
DP600 Certification
Thank you will for putting together this awesome content together. I passed my DP600 certification today. Couldn't have passed it without
11
6
New comment Sep 9
0 likes • Sep 9
@Naveed Ahamed What do you see as the biggest obstacle(s) when taking the test?
Slowly Changing Dimensions (SCD) Type 2 with Dataflow Gen2
Microsoft just released a new tutorial on implementing Type 2 SCD with a Dataflow: 👉🔗 https://learn.microsoft.com/en-us/fabric/data-factory/slowly-changing-dimension-type-two
21
19
New comment Sep 16
Slowly Changing Dimensions (SCD) Type 2 with Dataflow Gen2
0 likes • Sep 9
@Axel C. I'm sorry if I misunderstood your question. Basically we have 4 types of SCD. In SCD Type 2 you keep a history of changes in the Dim table. For example, imagine you have a Dim Customer, in which you have the address. If the customer changes their address and you want to keep the history, you have to create 2 date-type columns to indicate that from date X to date Y the customer's address was AAAA and that from date Y+1 to date Z the address is BBBB.
Fabric August 2024 update
Hey everyone, this week, Microsoft released the August update list, you can find them all here: https://blog.fabric.microsoft.com/en-gb/blog/microsoft-fabric-august-2024-update?ft=All What are your thoughts? Which feature stands out for you? Let us know below! 👇
9
11
New comment Sep 9
0 likes • Sep 9
Semantic-Link is fantastic, but it's still confusing for me because I have no Python background. I don't understand when pandas or fabric dataframes are used. For example, how do I save a list of all the datasets in a datalake? df_datasets = fabric.list_datasets(workspace='Reporting Live Specific')
1-9 of 9
Joao Monteiro
2
14points to level up
@joao-monteiro-1480
Passionate BI & Data Expert | Power BI Specialist | Data Analysis Enthusiast

Active 3d ago
Joined Jul 4, 2024
powered by