I Made My Filters Disappear!
Did you know that you can make your Power BI filter pane disappear? With the PowerPoint add-in for PowerBI this is quite easy to do, just look in the demo below!
Category: Uncategorized
Power BI Multiple Audiences management through Azure Data Factory and Active Directory
Power BI Multiple Audiences were released a few months ago and gave the opportunity to have one Power BI app with content dependent on the user. Before this you had to create multiple app workspaces and apps if different user groups need different reports, but now you can one app/app workspace for a subject are […]
Data Driven Disease Damage Control – Speaking at Pass Data Community Summit
Next week I will return to Seattle and the Pass Data Community Summit, and return to the stage to present a session on how we at NHO, the Confederation of Norwegian Enterprises, worked with data during the Covid pandemic. This have been a lot of work and is why my blog have been inactive for […]
A scalable solution for Datawrapper vizualisations with Data Factory and Databricks
During the Covid pandemic we at NHO (The Confederation of Norwegian Enterprise) have performed surveys with our members, which are Norwegian enterprises. We have asked them how business is going, if they fear bankruptcy, how the income is, and how they look at the next months going forward. Media and others have wanted this data […]
Posting to Workplace from Azure Data Factory
We recently started using Workplace (by Facebook) at work, so I wanted to check if I can add some data from our data warehouse as posts in groups. This turned out to be very easy, but worth a post. To set it up you go into workplace and settings for the group you want to […]
Comparing Databricks, Mapping Data Flows and SSIS as data transformation in ADF
I presented a session on SQLSaturday Oslo last weekend and can share some of the key takeaways here. This is by no means a complete comparison of every feature of these techniques, but show some of the strengths and weaknesses and can be a start when considering what tech to use in your Azure Data […]
From Excel to real-time Power BI with PowerApps!
At work we have a weight loss competition that was in full progress when I started there in June. After the summer vacation it’s time to start thinking about beach body 2020 and start again, but we received some scrutiny in the BI department that this was shown on a TV screen as an Excel […]
Starting and stopping SSIS Runtime with Azure Functions in ADF
SQL Saturday Oslo is approaching and I’m giving a session where I compare SSIS, Databricks and Mapping Data Flows for data transformation in Data Factory. One of the problems I got when setting this up is that when running SSIS in Data Factory you must handle the Integration Runtime and start (and stop) this efficiently. […]
Using Databricks delta to speed up Azure SQL load
If your organization doesn’t have enough data to require Azure SQL Warehouse with Polybase loading from data lakes, you might have observed that loading much data with Azure SQL databases can take some time. Today I show an example of how to use Databricks delta together with stored procedures to speed this up. The case […]
REST source and Parquet sink? Be careful!
I’ve been struggling a bit with creating a new blog post lately. I have built upon the blog post where I set up a way to call the Strava API to collect some data with REST APIs. I wanted to process this with Databricks, but have met some problems. They are related to how Data […]