24 lessons are prepared including theory, sometimes videos, quizzes, knowledge checks and challenges! The topic range from IoT Basics, how to interact with sensors, working with IoT data, security, IoT devices, …
If my time allows, I will definitely dive into some of the topics..
Have fun, enjoy learning and have a great #FreeAzureDataSummer
Today, I found some hidden gem in the Microsoft 365 portal. I was browsing through the list of available products and – for me totally new – found the Compare checkbox right next to the listed products. You maybe know that kind of feature from other web shops or product comparisons sites .. and the one in the M365 portal works the same 😉
Summer is approaching and now is the right time to use the long evenings to try out and learn more about the Azure Data Platform. This is the first part of a planned series of the Free Azure Data Summer – Today, it’s Azure Synapse free testing time…
The Azure Synapse team provides you with the opportunity of trying SQL Serverless pools and Spark pools for free until the end of July 2021.
Another small but very powerful usability extension in Azure Synapse Studio was added at the beginning of June: Move artifacts across folders in Synapse Studio (without extra clicks but with drag&drop)
Once again, the release notes list contained the short sentence that made me curious… hmm… that sound nice… In one of my previous post, I described the “old” way of moving artifacts around in Synapse Studio.
Let’s try it out..
Well, what should I describe the process – it’s simple as usual 😉 Have a look at the animated GIF to see it in action.
Let’s call it by accident, that I found out that Azure Synapse Analytics now let’s you to link more than just one Power BI workspace.. There is an entry in the Release notes/Update menu that lists this option.
The past: limit to only one linked Power BI Workspace
In one of my previous blog posts, I referred and mentioned the limitation of having a maximum of one linked Power BI workspace…
The present: Link multiple Power BI workspaces
The process is the same as in the past – Open the Manage Hub in Synapse Studio – Linked Services – and add an additional workspace link.
Head over to the Develop Hub and refresh the Power BI section – et voila – there are two Power BI workspaces listed now!
In my case, the option to add multiple Power BI workspace links is a really required one. In most of our projects – or in all of our projects – we are not only using one Power BI workspace! In the past, this required us to switch to another browser window to open the Power BI portal directly… not more…
Have fun – with the Power BI integration in Synapse Studio!
Today is the day of #DataMinutes – the fastest event in the Microsoft Data Platform space. A day full of 10 minutes sessions – 84 sessions, 2 tracks and two organizers – William and Ben have again prepared a great schedule..
If you have 10 minutes left today, head over into one of the two tracks – the Bar or the Grill and listen to one of the sessions!
The schedule is published here – as are the links to the teams meetings.
If you are new to Power Query and want to know more about it, join my session at 11:30 am!
Power to the Query!
You have not heard about Power Query? You are not sure how this YADI-tool (yet-another-data-integration-tool) can help you? Let’s see where Power Query already has its place in todays tool landscape and how you can easily start using it.
You already may be familiar with Azure Purview (first look)- the Azure data governance / data catalog service. In the last months, I got the chance to work on PoC projects together with customers and use & test Azure Purview in several demo instances.
SQL Views are not recognized by Purview scanners
There was one big thing missing so far – the scanning of SQL Server / Azure SQL Views. Which – well – in many cases (customer databases) was a huge loss of information in the data catalog.
This known limitation is listed on the documentation page but many of us overread this sentence.. 😦
My demo database contains several tables plus two views (depending on tables in the same database – “simple SELECTs”)
After a scan in Purview, the list of artefacts looks like this:
But…. look what I’ve found today.. SQL Views in Azure Purview
But look what I’ve seen today… there are two more items in the Purview assets list 😉 Azure SQL Views
The View metadata is read – including schema
BUT: what Lineage information still missing. This would be the extra bonus piece to have the data lineage for views included. But this is the implementation of today, let’s wait and see what future updates will bring.
One step into the right direction – SQL Views are now recognized by Azure Purview scanners. BUT: what really, really, really (@Azure Purview team ;-)) would kick this feature… data lineage for views 😉