A Fine Slice Of SQL Server
Kevin Chant checks the burndown:
In this post I want to cover using Azure DevOps Analytics views and Microsoft Fabric to create Sprint review dashboards.
I consider this post to be a sequel to one of my post popular posts that covered using Azure DevOps Analytics views and Power BI to create Sprint review dashboards. For four very good reasons.
Read on for those reasons, along with the steps Kevin took.
Comments closedReza Rad does more than copies:
Copy Activity is one of the most commonly used activities in Microsoft Fabric’s Data Factory Pipeline. The Copy Activity copies the data from a source to a destination. However, there is more to that rather than just a simple copy. In this article, you will learn what Copy Activity is, its rationale, how it works, and its configuration options.
Reza has a video, as well as a demo-heavy full-length article on the topic.
Comments closedBrian Bønk does some data shuffling:
The Fabric servive Eventstream can read data from an Event Hub service to help collect data from IoT devices and other streaming services. But how do you configure the Event Hub and Eventstream to work together?
I’ll try to help with that in this blogpost.
Click through for the article, which provides a how-to guide on the topic.
Comments closedReitse Eskens checks the logs:
I reported an issue yesterday with Microsoft Support and during the following call today (they’re really quick to set up an initial meeting), the support engineer showed me where I can find a lot of logging information.
Suppose you’ve got a notebook that has been run a few times. The front-end will only retain the information from the last run. If you see an error, for example this one
Click through to learn where you can find these execution logs.
Comments closedAimee Johnson explains how Microsoft Fabric licensing works:
Microsoft Fabric is a Software-as-a-Service platform (SaaS) which enables you to build an end-to-end analytics solution without the need to spin up complex infrastructure. If you want to know more about Microsoft Fabric then check out our introduction blog post which you can find here.
Since Microsoft Fabric has been announced there have been many questions and queries about licensing and in this blog post I will go through everything you need to know!
One thing I keep forgetting is that Power BI Premium P1 is equivalent to Fabric F64; I keep wanting it to be F32 or F16, but that’s because I’m frugal that way.
Comments closedReitse Eskens uploads some data:
In a blog from a few weeks ago, I wrote about getting data from your on-prem SQL Server into Fabric. At the time, the only option for a copy dataflow was using a direct connection over the internet. It still is, but now you can also use the PowerBI Data Gateway to get data from your SQL Server into Fabric.
In this blog, I’ll take you through the steps needed and an issue I ran into.
Read on for Reitse’s instructions and how to avoid the issue he ran into.
Comments closedThere is a tool (or you can consider it as an editor) in Fabric for data scientists. As a data scientist, you must work with the data, clean it, group it, aggerate it, and do other data preparation work. This might be needed to understand the data or be part of the process you do to prepare the data and load it into a table for further analysis. Data Wrangler is a tool that gives you such ability. You can use it to transform data and prepare and even generate Python code to make this process part of a bigger data analytics project.
Data Wrangler has a simple-to-use graphical user interface that makes the job of a data scientist easier.
Read on for a video as well as a demo in written format.
Comments closedJordan Witcombe takes us through an example:
This blog will walk you through the entire data lifecycle of ingesting data from SharePoint and Azure Blob Storage, through the lakehouse pattern, and finally to the reporting stage – all using Microsoft Fabric.
As we’re well into summer now, festivals can be a great way of spending time with friends and family. But all too often, we each want to see various acts and activities. How can we make this easier? With this dataset I created, it takes a simple Excel / CSV file with acts, stages, who wants to see this, and a personal rating. We will run this through the lakehouse pattern and finish with a curated/gold layer which can be used for reporting directly on top of. For more information on lake layers, you can see Ed’s blog Medallion Architecture: What is it?. So, you can highlight those clashes and keep everyone happy during your festival fun!
Read on for the showcase.
Comments closedKevin Chant gets a jump on a big problem:
To manage expectations, this post only covers database schema objects. Plus, I need to highlight the fact that this solution has some interesting quirks. Some of which I highlight in this post.
Even though there are some quirks, I still want to show this solution. So that others can see it working and I can highlight a few important facts. Plus, share a template you can use to test this yourself.
The current lack of a good migration strategy is a real challenge for anyone thinking of moving from Azure Synapse Analytics to Microsoft Fabric. Serverless SQL pools and Spark pools are an easy transition, but dedicated SQL pools are a tough nut to crack.
Comments closedTeo Lachev talks semantic modeling:
In retrospect, I’d say I owe 50% of my BI career to Analysis Services and its flavors: Multidimensional, Tabular, and later Power BI. This is why I closely follow how this technology evolves. Fast forwarding to Fabric, there are no dramatic changes. Unlike the other two Fabric Engines (Lakehouse and Warehouse), Power BI datasets haven’t embraced the delta lake file format to store its data yet. The most significant change is the introduction of a new Direct Lake data access mode alongside the existing Import and DirectQuery.
Read on for Teo’s thoughts. I think there’s a good chance that the Bad/Ugly points will be eliminated by the time Fabric goes GA, though we’ll have to wait and see if that’s the case.
Comments closed