So I have choose Lake Database not the SQL Database which is why I am unable to see SQLPool in Power BI setup and hence.
Now I have to connect Lake database to Power BI.
forget delta and medallion and all since at least 40 years, you get raw data in a folder then you load it into a database, this is how it works for every DWH include SQLPool thing
@@ROWCOUNT in #Synapse Dedicated #SQLPool
If you’ve been working with dedicated SQL pools in Synapse, you'll know @@RowCount is not supported...😰
WORKAROUND BELOW!⬇️
purplefrogsystems.com/2023/0…
1 day till the make-up session - The power of Synapse SQL Pool session by Michelle Gutzait and Christian Cote on March 29, 2023 @ 7PM PST/UTC-8
RSVP here: buff.ly/3yYI0gx#ladataplatform#synapse#sqlpool#etl
This week's make-up session - The power of Synapse SQL Pool session by Michelle Gutzait and Christian Cote on March 29, 2023 @ 7PM PST/UTC-8
RSVP here: buff.ly/3yYI0gx#ladataplatform#synapse#sqlpool#etl
We used Serverless #SQLPool for storing detailed data, Dedicated #SQL Pool for data marts, and #Synapse Pipelines were utilized as a tool for extracting, transforming and loading the data (ETL).