Azure SQL firewall settings for Power BI refresh
I do not claim that what is included in this post is the perfect way of doing things. However, some things related to Azure SQL firewall settings for Power BI data refresh caught me by surprise recently…
Fixing ‘subscription is not registered with NRP’ error in Azure
Today I hit the following error while trying to write a PowerShell script to automate some Azure Networking related tasks (more on that soon!): 'Subscription [subscriptionID] is not registered with NRP'. In this short post I will…
Microsoft’s Language Understanding Service now speaks Dutch
Over the weekend Microsoft’s Language Understanding Service (LUIS) which is part of the Cognitive Services and the Cortana Intelligence Suite was updated to support the Dutch (Nederlands) language! Great news for anyone who needs to support Dutch…
Implementing incremental data load using Azure Data Factory
Azure Data Factory is a fully managed data processing solution offered in Azure. It connects to many sources, both in the cloud as well as on-premises. One of the basic tasks it can do is copying data…
SQL Server news from connect start to resonate
Hi all, A month ago at the Connect event in New York Microsoft did some anouncements on SQL Server vNext and Azure Data Services. It’s good to see the traction it’s getting! I work with a lot…
Passing filters to Power BI reports using the URL / query string
It was only recently that I discovered this – you can pass filters to Power BI reports by deep linking to it and adding a filter in the URL (also called query string). I am not even…
First look: Esri ArcGIS Maps in Power BI
Esri is a leader in the GIS industry and ArcGIS is a very popular product to build great maps. Now, you can use ArcGIS maps in Power BI (in preview). See the official information here: https://powerbi.microsoft.com/en-us/blog/announcing-arcgis-maps-for-power-bi-by-esri-preview/. This…
Adding sequence numbers using R in Azure ML
When going through data preparation sometimes sequence numbers need to be added. If you are like me, you probably spent some time looking for a component in Azure ML to do this. I never found it. Turns…
Power BI Refresh scenarios against data storage solutions explained
A recurring theme with customers and partners is Power BI data refresh. More specifically, there is some confusion on what refresh scenario requires a Pro version and what can be done with the Free version of Power BI.…
Azure Machine Learning pricing explained
Many customers asked me questions on Azure Machine Learning (Microsoft’s fully managed machine learning and data mining solution) and more specifically on it’s pricing. In this post I will try to explain how the pricing works and…