Export data from Power Query to Local Machine or SQL Server using R scripts

There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show how to do it by writing R scripts inside Power Query.   First how to Store Files to PC To store data back to a file Read more about Export data from Power Query to Local Machine or SQL Server using R scripts[…]

Applied more Analytics on your data with Key Influencer Visualization

In this post, I am going to demonstrate a new visualization that has been released by the AI team in Power BI in recent months. Before showing off the nice features, there are some key points about this visual. http://datascientistyuyuria.blogspot.com/2017/06/ It can be used by Data sciences, Data engineer and End users.  It is easy Read more about Applied more Analytics on your data with Key Influencer Visualization[…]

AI in Dataflow, Power BI webservice, Cognitive Service -Part1

These days, Dataflow (Power Query in Power BI Service) is a new feature that has been released. according to[1]: Dataflow is a Power Query process that runs in the cloud independently from any Power BI reports. If you want to know more about dataflow see [1]   There is a new feature in dataflow that Read more about AI in Dataflow, Power BI webservice, Cognitive Service -Part1[…]

Face Recognition Application with Power Apps, Microsoft Flow and Cognitive Service -Part 3

A new posts series has been started on how to create a simple application for the aim of face recognition with Microsoft Flow, Power Apps, and Cognitive Service. In the first post, the process of setting up power apps has been explained, in the next one how to set up the Microsoft flow for the Read more about Face Recognition Application with Power Apps, Microsoft Flow and Cognitive Service -Part 3[…]

Create Microsoft Flow Part 2- Face Recognition by Power Apss, Microsoft Flow and Cognitive Service

  In this series the process of how to create a simple applicaiton for facial recognition has been explained. In the last post, the process of creating Power apps for taking the photo has been explained. In this post, the process of creating face recognition function in  Microsoft Flow will be explained. In the next Read more about Create Microsoft Flow Part 2- Face Recognition by Power Apss, Microsoft Flow and Cognitive Service[…]

Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 3

  In the last two posts (Post1 and Post2), the process of how to set up a simple Power Apps for the aim of converting the image to text has been explained. The created Power Apps capture a picture from a receipt or any text.  Also, how to create a flow that received the image Read more about Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 3[…]

OVERVIEW ON MICROSOFT MACHINE LEARNING TOOLS

Microsoft Machine Learning Technologies Overview Artificial intelligence and specifically Machine learning can bring lots of benefit to the business owner. Many businesses using Microsoft data platform tools for many years. Microsoft employed machine learning in creating their products such as Xbox, Bing Search and so forth for a while. However, from 2014 they start to Read more about OVERVIEW ON MICROSOFT MACHINE LEARNING TOOLS[…]

Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 2

In this post, I am going to show how to connect the Power APP, that you created in Part One for the aim of taking a photo from your receipt, send it to the Microsoft Flow and cognitive service to convert the image to text. First, you need to follow the link for the creating Read more about Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 2[…]

Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 1

For a month I am looking to create a Microsoft App that user able to take a picture from an invoice then able to see the items in Power BI or store it in storage such as SQL server, excel and so forth. In this posts, first I will show how to create a Power Read more about Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 1[…]

Power BI and Azure ML make them work with Power Query

In this blog post, I am going to show how to use the Azure ML web service in Power BI (Power Query). First Step: You need to create a model in Azure ML Studio and create a web service for it. The traditional example in Predict a passenger on Titanic ship is going to survived Read more about Power BI and Azure ML make them work with Power Query[…]