Category Archives: Business Intelligence

Data Types Conversion Matrix in Power Query

Another useful page for my future reference – Data Types in Power Query describes the available datatypes PLUS a very, very useful Data Types conversion matrix. Convert a decimal number to a date? yes, no, maybe, with a loss of … Continue reading

Posted in Best Practices, Business Intelligence, InformationSharing, PowerBI | 1 Comment

Connectors in Power Query (reference link)

Sometimes even the internet has some real treasures hidden and I found on this weekend. In many workshops my customers ask me – “Wolfgang, is connector to system XYZ supported in Power BI datasets AND dataflows?” .. and in some … Continue reading

Posted in Azure, Business Intelligence, Cloud, InformationSharing, PowerBI | Leave a comment

Continuous Integration for the BI Team session at ExpertsLive Austria 2021

It’s my first conference in 2021 – and it was planned as a local one.. but as things changed the ExpertsLive Austria 2021 conference went virtual too.. I am speaking today about Continuous Integration for the BI Team: In many … Continue reading

Posted in Azure, Business Intelligence, Conference, PowerBI, SQL Server | Leave a comment

Azure Synapse Analytics end-to-end: From your database and sensors to a Power BI dashboard

In todays blog post I would like to build an end-to-end solution to combine data coming from different sources and stored in different form factors into a single Power BI data model using Azure Synapse Analytics. The Basics to start … Continue reading

Posted in Azure, Azure Synapse Analytics, Business Intelligence, Data Lake, InformationSharing, PowerBI | 1 Comment

Create a new Power BI report and dataset (simply in the service, without Power BI Desktop)

In December, the Power BI team released a new feature to create reports in Power BI service. Which does not sound new, right? Since the beginning of Power BI, you could create a new report in the service.. but now, … Continue reading

Posted in Business Intelligence, Cloud, PowerBI | 1 Comment

Speaking at ExpertsLive.at about Continuous Integration for the BI Developer

The new year is only one day old and I am happy to announce that I will speak at the 2021 edition of Experts Live Austria conference on Friday, 8th January 2021 It will be an online event and I … Continue reading

Posted in Azure, Best Practices, Business Intelligence, Conference, PowerBI | Leave a comment

DirectQuery for Power BI Datasets – What does Chaining mean?

In my last blog post I introduced the new concept of DirectQuery for Power BI datasets. This feature allows you to extend and modify a (remote) published Power BI dataset with the help of a local model. The local model … Continue reading

Posted in Business Intelligence, InformationSharing, PowerBI | 1 Comment

An Event On How To Shape Your Future with Data and Analytics?

Twitter Hype? The messages from the Azure Synapse Analytics sound more than interesting to me (link to the tweet) Or this one (tweet) What are they talking about? Well, they are announcing and promoting the digital Azure Data and Analytics … Continue reading

Posted in Azure, Azure Synapse Analytics, Business Intelligence, Conference, Data Lake | Leave a comment

Direct Query your Data Lake Files using Azure Synapse Analytics and Power BI

The usage of Data Lakes in a Modern Data Warehouse / Data Platform is getting more and more popular. Fed by different kind of data sources, a data lake is very often used as a cheap, easy to handle and … Continue reading

Posted in Azure, Azure Synapse Analytics, Business Intelligence, Cloud, Data Lake | 6 Comments

SQL Saturday Denmark #963 – Virtual

Today, I presented a session at this years #SQLSatDenmark which went virtual and online this year. The organizers provided us with five parallel tracks and overall 29 sessions over the day. I presented my session “Continuous Integration for the BI … Continue reading

Posted in Business Intelligence, Conference | Leave a comment