A Few Ways GENERATE_SERIES Will Revolutionize Your Microsoft Fabric Warehouse Experience

Posted on by Annie D

Want to create a series of data within a Microsoft Fabric Warehouse? Patrick looks at how GENERATE_SERIES can help you instead of doing INSERT after INSERT which doesn’t perform well.

Scripts: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Fabric/20241017%20-%20Generate%20Series.zip

GENERATE_SERIES (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16

GENERATESERIES – DAX Function
https://dax.guide/generateseries/

Brad Schacht
https://x.com/BradleySchacht
https://www.linkedin.com/in/bradleyschacht/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— <a href="http://twitter.com/patrickdba" target=”_blank” rel=”nofollow”>http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#MicrosoftFabric #Warehouse #GuyInACube

Guy in a CubeFri, October 18, 2024 2:10am