Do you know how many videos out there that I've found that shows me how to set up a data warehouse like this? One. This one. Thank you for this!
@Success4peace11 ай бұрын
Suggestion: Please do more Fabric videos with focus on Notebooks and analytics like common enterprise needs around price prediction, demand forecasting etc. This will help us the power bi users learn some data science and learn how to use notebooks as well.
@dagg4974 ай бұрын
Notebooks as in Apache Spark and Databricks? That's a monster to try and learn especially Scala or Python
@balajisuriyanarayanan65455 ай бұрын
Thanks you so much for the wonderful videos. Its really helped me a lot and Today I have cleared my DP-600 exam🎉
@NoCompM211 ай бұрын
Patrick, can you please do some videos on how to take weekly raw data files and save them each week with a date stamp to keep historical records? That would be awesome. Basically same files each week, and append them to create a large system of weekly records
@rdeheld11 ай бұрын
I used SSIS for some years but this is next level 😀
@MohanadPC11 ай бұрын
Q: why would we need Fabric when we can use Azure SQL and grab data from there? Any response is appreciated , thanks
@peterjohannessen992811 ай бұрын
Well you could of course use Sql but Fabric is much bigger than that. With SQL you would need to do a lot of ETL work and set up permissions, maybe copy data do fifferent marts etc. Fabric helps you with that and you can create shortcuts to reuse your data easily. Not to mention yo can create and save DAX queries so they are reuasble by anyone connecting to that source
@lukaszk438811 ай бұрын
Hey Patrick ! This is great video showing example . I wold like to see more store procedures examples like making scds . Cheers !
@Checha_AFG3 ай бұрын
You are a hero man
@mirrrvelll51647 ай бұрын
This is actually great with DWH. But, after I am seeing this, there is a lot of options here, lot of clicks, and you need to know what you are doing. I was considering to get Fabric in our company, but I think the good thing is to have someone who is doing ETL (SQL programming) with Management Studio and prepare all the stuff. This way from Power BI (Fabric) is okay, but why to complicate when there is no need to it.
@petrnovotny90739 ай бұрын
thanks! you are the best, nice summary!!
@bennetturner62619 ай бұрын
This is great. What I would like to achieve with all these new MS tools is ETL that watches a folder inside OneLake (or SharePoint) and when I add a new flat file (csv) to the folder it parses it and appends parsed rows to OneLake db. Then this data is available in PBI. This would be an amazing tutorial if you could provide one.
@ankeet18 ай бұрын
We used a tool called VisualCron to watch folders for files and run ETL into Azure SQL database. Not sure of the compatibility here though.
@germanareta726711 ай бұрын
Great video, thanks :)
@SilvanoPaxia11 ай бұрын
Great, unfortunately for now Identities columns are missing. Can you do some video on SCD Type 2 Dimensions?
@didiermaignan764005 ай бұрын
Great video, Patrick 🙃 If I look at Datamart, which you demoed last year, I can see common ideas, such as having everything together, but very different way of doing things and different audiences (Datamart for citizen dev and datamesh oriented, Data WareHouse for Data Office and IT). Since datamart are in preview since feb 2022 (2 years ago, waouh!) and have a proximity with Dataware House (Get data, create measure, do SQL queries etc...Do Microsoft intend to give up datamart in favor of Fabric Data Warehouse?
@sathyamanikantabk448311 ай бұрын
All this what you showed Can we do it also if we are having Microsoft Developer account?
@Sandroider11 ай бұрын
It was all fun and games until I needed premium capacity.
@artus19810 ай бұрын
Isn't fabric the next version of Synapse ? Also what are your thoughts on Databricks delta lake tables ? As a seasoned SQL developer, fabric is very familiar , it's T-SQL and GUI !
@diegoc308611 ай бұрын
thx for the fabric vid
@mariodukez6610 ай бұрын
Exciting capabilities!
@jasonlarson988610 ай бұрын
Curious to know how to deal with encrypted data in Fabric, and how we can decrypt those values in power automate/apps.
@user-dy8xu7uj8k2 ай бұрын
Hi Good Morning!, I have to convert the existing SQL server stored procedure into fabric environment, In my stored procedures there are CURSOR commands but fabric doesn't support CURSOR commands, in this case how do I proceed, is there any alternative.
@thghtfl9 ай бұрын
What is the price for this warehouse feature? If I don't need a full-fledged warehouse solution, will it be a cheaper option?
@Fernando_Calero5 ай бұрын
Q: How often do you update the Producers list credits at the end?
@IrishJimmyPA11 ай бұрын
Q: Is any of the configuration scriptable, or do you have to go through the GUI?
@lassenikolajsen61317 ай бұрын
Q:When you add the new schema it seems like the information_schema is removed. Is this something you do that we don't get to see, or is the informaiton schema automatically removed when you create new schemas or where can they be found?
@square007tube11 ай бұрын
Hi, I don't see data activator in my trial version, how to show it my MS fabric Home screen? Thanks.
@DanielWillen11 ай бұрын
I assume Data Warehouse would be better than a lakehouse if you are heavy on TSQL. I am curious though if it would be worth migrating from something like serverless sql pool to a datawarehouse. Serverless can already read csv and parquet files from the azure storage account . What are the advantages?
@migcramer9 ай бұрын
I have the very same question! I hope someone can Reply to you/me on this. Especially if this has been covered on another video or post. Thanks Daniel!
@naveenhasan793911 ай бұрын
is the data warehouse only available in premium capacity or also as part of PPU or Pro. what would be the advatnage of using this over and above a data warehouse deployed on my local server?
@JohnKpl11 ай бұрын
Isn't it better to use TRUNCATE instead od DELETE in SQL?
@emirtuncer6 ай бұрын
it depends
@Sandroider11 ай бұрын
I was able to do this without premium capacity, what are the the needed ”... so we can use some Fabric items” 00:57 ?
@damiancz233911 ай бұрын
Q: what about using setup of active directory to limit access to data for all of possible users? Is this possible? (Not rls on dataset)
@RobertBuk11 ай бұрын
Hi, thanks for your video, seems that Microsoft is preparing their platform that all DWHs should run in the future in the cloud. So could you show us how to implement a SC2 historization here? thanks
@sudhamadhurikandru270811 ай бұрын
looks a copy of snowflake,, style of creating warehouse
@altonmabina11 ай бұрын
greate video, this will help me with my thesis, i have few questions to ask , i wish i had your email such as i can i tell witch data warehouse model are u using or chosen