Category Archives: Business Intelligence

Ignite 2022 – Azure Data Platform Update

It’s the week of Ignite 2022 and as in the last years, many new features and updates have been announced. It’s hard to catch up with all the tweets, blog posts and similar things so I will recall the good … Continue reading

Posted in Azure, Azure Purview, Azure Synapse Analytics, Business Applications, Business Intelligence, Cloud, Conference, DataNews, Microsoft Purview, PowerBI | 1 Comment

Complete Analytics Fabric – Azure Synapse and Power Query (Power BI) better together

As a follow up of todays PASSDataCommunitySummit keynote, in which Arun Ulag mentioned a new phrase – the Complete Analytics Fabric, I would like to write more about a new option to really get a complete picture of your Azure … Continue reading

Posted in Azure, Azure Synapse Analytics, Business Intelligence, PowerBI | Leave a comment

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 | 2 Comments

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