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 😉
PowerPlatform Dataflows –PowerQuery (and more) in the Cloud
With PowerPlatform dataflows, users can bring PowerQuery functionality to a cloud-only life. Created in the cloud, processed in the cloud and storing results in the cloud, dataflows can be seen as cloud native part of the ETL within the PowerPlatform. After their initial start in the Power BI universe, they now reached out into other parts of the PowerPlatform and be one of the future options of ETL pipelines to transfer data into data lakes. In addition to data transformation, dataflows can be enriched with AI functionality to bring more ML power into your ETL processes. Join this session if you want to learn more about the current feature set available and see what is new and possible with data preparation in the cloud with PowerPlatform dataflows.
This weeks roundup is focused on the Power BI announcement from the MicrosoftBusiness Applications Summit 2021. The event was virtual this year and the sessions are now available as on-demand sessions (browse to mymbas.microsoft.com).
If you don’t have much time, take an hour and watch the two Power BI keynotes… many, many interesting things have been announced.
Tuesday, 4th May: The Business Applications Summit 2021 – virtual and one day – takes place on May 4th, 2021 – Register for free and get all the news about Power BI and the Power Platform tools – https://mymbas.microsoft.com/home
After the initial announcement of the competitive price for Power BI Premium per User (PPU) (20$/user/month) AND the add-on price for existing Power BI PRO users ($10/user/month) the questions from our customers how to purchase the add-on arrived.
This blog post is here for future Wolfi – How to quick and easy find the Power BI Premium per User add-on license.
Initially I told my customers, purchase the PPU license in the Microsoft 365 portal and thought that it should be an easy deal.. but hey – it’s licensing, Microsoft licensing involved…
The place where to buy the PPU add-on is not that obvious as it looks like.
In the services catalog, let’s search for “Power BI” and have a look at the result list. The result list only contains one entry for the PPU license which is the “full” PPU license, not the upgrade.. hmmm…
Clear the search results.
Select the Add-ons category and search for Premium. Et voila – here it is .. the Add-On license for your existing Power BI PRO license..
If you know the answer where to find the upgrade license, it’s easy…
Ich muss es nicht schönreden – das Gefühl, sein eigenes, gebundenes, fertiges Buch in den Händen zu halten ist schon ein schönes 😉
Die erste Ausgabe von Power BI für Dummies erschien im Dezember 2019 und irgendwas dürften wir richtig gemacht haben – der Lagerbestand der ersten Auflage neigte sich dem Ende zu und außerdem erfuhr Power BI sehr viele Updates und neue Features, dass der Verlag gemeinsam mit uns die Entscheidung traf: Es ist Zeit für eine 2. Auflage!
Nach dem Veröffentlichungsdatum am 14. April 2021 war es heute endlich soweit: das Paket von Wiley lag vor der Haustür… darin enthalten: meine Autorenexemplare!