Microsoft Bot -Part2: Create a Question and Answer

In the last post, I have shown how to create a simple Bot. In this post, I am going to show how to create a Question and Answer Bot and embed it in a website. To start you need to create a Web App Bot in Microsoft Azure with Bot Template as Question and Answer. After creating the Read more about Microsoft Bot -Part2: Create a Question and Answer[…]

Microsoft Bot -Part1: Create a sample

Using Microsoft Bot in applications and report make them more agile and interactive. there are many ways to use Microsoft Bot. In this posts and the next one, I will explain how to create a Microsoft Bot in Azure and then embed it in your PowerBI and messenger like Facebook messenger or Telegram. How to Read more about Microsoft Bot -Part1: Create a sample[…]

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 about Composite Model; DirectQuery and Import Data Combined; Evolution Begins in Power BI[…]

Microsoft Business Applications Summit – 2018 Keynote (Live Blog)

I have front row seats at the keynote that will begin shortly.  As features and announcements are made, I will update here. The room is massive and filling fast.  I’m sitting with some true legends in right by the stage and there is an electric buzz in the air. And we are underway. Power BI Read more about Microsoft Business Applications Summit – 2018 Keynote (Live Blog)[…]

Power BI Helper Version 3.0 Export Model Documentation

It is a pleasure to announce the newest version of Power BI helper, version 3.0 July 2018 with the great feature of exporting model documentation. The documentation part of the insight from Power BI Helper has been always in our backlog, but haven’t had a chance to work on it. Gladly now you can export Read more about Power BI Helper Version 3.0 Export Model Documentation[…]

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 about Sharing Power BI Reports with Selection of Slicers and Filters; What it Means?[…]

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 about Live Machine Learning in Azure Stream Analytics-part 2[…]

What is the Direction of Relationship in Power BI?

Relationships in Power BI are a bit different from other database management systems. In most of the systems, you just have a relationship and there is no “Direction” for it. In Power BI, however, there is a direction for the relationship. The direction of a relationship plays a critical role in the way that filtering Read more about What is the Direction of Relationship in Power BI?[…]

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 about Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI[…]