Composite Model; DirectQuery and Import Data Combined; Evolution Begins in Power BI

With the new announcement of Power BI Desktop release of July 2018 at Business Applications Summit, the break-through feature is the ability to create a composite model. Now you can have part of your Power BI model to come directly from a data source, and another part to be imported. Along with this change, you ...

Read More

Fun with DAX – Tic Tac Toe

Posted by on Jul 17, 2018 in Power BI | 4 Comments

To follow in the spirit of some of my recent blogs, I thought I would have a look to see how feasible it might be to build a Tic Tac Toe game using just DAX and Power BI.  I get pretty close and will detail my approach here in this article.  For starters, here is ...

Read More

Sharing Power BI Reports with Selection of Slicers and Filters; What it Means?

  The most recent feature added in the Power BI service is a great update, which should not be overlooked. You can now share reports and pass the selection of filters and slicers. This ability, which is announced yesterday, open doors to many possibilities. You can now create “report views” for different personas of users. Previously ...

Read More

Live Machine Learning in Azure Stream Analytics-part 2

In last Post, I have explained the process of creating Event Hub, Stream Analytics, and Azure ML model for the aim of applying machine learning to streamed Data. In this post, I will show how to create a function in Stream Analytics for calling the Azure ML API and finally see the result in the ...

Read More

Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI

Sometimes for tables with too many columns, and also for databases with too many tables, you do need a bit of help to explore the data. As an example; you know that you are looking for a column named “account status”, but the column does not exists in the accounts table. You need to search ...

Read More