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

Memberships

Learn Microsoft Fabric

14.3k members โ€ข Free

HYBRID HEROES

1.8k members โ€ข $9/m

8 contributions to Learn Microsoft Fabric
SOLVED : Named pipes <> TCP/IP
Hi all, I'm setting up a 'Dataflow Gen2' from an on prem sql to a WH in fabric. I can get my queries from the local DB, but when I want to configure a data destination, I get this error the moment I want to create the destination table. The error says it wants to connect to the server through named pipes, but named pipes is not enabled on the server. I don't manage the server, so I don't know why it is not enabled and if the managing party want to enable it. Is there a way to use TCP/IP for this? TCP/IP worked in the first step, so why not here....?
SOLVED : Named pipes <> TCP/IP
3 likes โ€ข Aug '24
The problem is solved. On the on-prem sql-server, we had to add an OUTBOUND rule for TCP port 1433 We had an inbound rule, so that's why I could query the data in the first step. Once we added the outbound rule, it all worked immediately. Hope someone gets to use this information.
1 like โ€ข Nov '24
Hi @Adolfo Illera Jimรฉnez. I don't know exactly. It is an external party that manages the firewall and on-prem sql server. Maybe this is a starting point: https://superuser.com/a/1746792
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! ๐Ÿ‘‡
3 likes โ€ข Sep '24
This: Truncate Table Truncate Table in Fabric Datawarehouse, enhancing data management capabilities for the users is now generally available. And new/updated gen2 connectors is always good. :)
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
Slowly Changing Dimensions (SCD) Type 2 with Dataflow Gen2
0 likes โ€ข Aug '24
@Gediminas Juskenas So when the address changes in 1/1/2024, and I query the data (in a power BI) in the range of 2023, I should get the old address and when I query today, I get the new address? Or is it pure hystorical retention in the database?
1 like โ€ข Aug '24
@Gediminas Juskenas Makes perfect sense. Thank you very much.
Get discounted access to new Microsoft Fabric Udemy course
Hey everyone, a friend of mine Malvik Vaghadia has just released a brand new Udemy course on Microsoft Fabric. I've reviewed the course, and it's really comprehensive, and Malvik is a great instructor with lots of experience teaching on Udemy and on his YouTube channel. Try this link for FREE access (first 100 only, first come first served): ๐Ÿ‘‰๐Ÿ”— EDIT: *Link Removed Because All Coupons Have Been Redeemed* You can then use this link for a heavy discount (68% discount, I believe): ๐Ÿ‘‰๐Ÿ”— https://www.udemy.com/course/microsoft-fabric-the-ultimate-guide/?couponCode=LEARNFABRIC ๐—ช๐—ต๐—ฎ๐˜ ๐—ฌ๐—ผ๐˜‚'๐—น๐—น ๐—Ÿ๐—ฒ๐—ฎ๐—ฟ๐—ป: โœ… Data Warehousing: Understand the principles of data warehousing, master SQL for querying and managing data, and learn how to design and implement data warehouses within Microsoft Fabric. โœ… Power BI: Create powerful, interactive reports and dashboards. โœ… Data Engineering: Develop robust data engineering pipelines using Spark (PySpark), manage large-scale data transformations, and automate workflows efficiently. โœ… Data Factory: Master the use of Data Factory for orchestrating and automating data movement and transformation. โœ… Real-Time Intelligence: Leverage real-time data processing capabilities to gain instant insights and act swiftly in dynamic business environments.
Get discounted access to new Microsoft Fabric Udemy course
1 like โ€ข Aug '24
At all the people who snagged a free licence... How detailed is the course? Is it just stepping through the screens and buttons, like a tutorial or do we really get the details to know tricks, that take your knowledge to the next level?
Create your CV in Power BI
Last week I landed a new job in a company in the forefront in Fabric (and Tabular Editor) in the Nordics. I think creating a CV in Power BI helped. Maybe you can find some inspiration from the one I created. Link to CV. Recently also How to Power BI released some ideas on this topic: https://www.youtube.com/watch?v=GkDOIRYiGFg Background: Coming from the Power BI/ user side, I have previously found it hard to apply for jobs, getting the following reply "we had a candidate with more database competence". I was about to send a CV in pdf, when I went to the grocery store and listened to Explicit Measures Podcast (recommended), where they advised to create it in Power BI to show your skills. Two days later, the CV was sent in Power BI and a few hours later the first interview was booked. Much more fun then creating a PDF. And no recruiters I talked to had seen this before and one said it was the most impressive he seen in 20 years (writing CVs is not my strength). They were all enthusiastic about it. Also used some statistics from this site to show my interest in Fabric (a comment I read from @Will Needham ). For improving it further, maybe I could add a hobby-project as well, such as getting data from Strava (to combine work and spare time interests). Good luck if you are looking for new opportunities.
1 like โ€ข Aug '24
This is a very creative way of showing your skils. Well done.
1-8 of 8
Axel C.
2
1point to level up
@37430799
I'm a software developer, switching from VBA to fabric. :)

Active 10d ago
Joined Jul 12, 2024
Belgium
Powered by