Using Cognitive service for Translation in Power BI

There is a possibility to call cognitive service for translation inside Power Query. I will use this to translate 3000 rows of data about people arrested in Iran for protesting; This information contains city Name, Fullname and Other statements. In this article, I will show how to call cognitive services for translation, create a proper Read more about Using Cognitive service for Translation in Power BI[…]

Azure Machine Learning Call API from Power Query

This was my longtime aim to create this post, and finally, I will write about it here on how to call Azure ML Rest API inside Powe Query even if you don’t have Power BI Premium.Of course, some limitations on the number of API calls need to consider while using your Rest API.Thanks to Chris Read more about Azure Machine Learning Call API from Power Query[…]

Template Power BI File for Sessionize.com

Organizing events always start with session selection and finally creates a schedule on it. As I was busy always with community activities, I am using sessionize website a lot, this website is free of charge for free and nonprofit conferences, but for the paid conference, you need to pay as you using it ( fair Read more about Template Power BI File for Sessionize.com[…]

Sort Column Name in Power Query via M Code

Sometimes people ask questions about how to order columns in Power query, mostly for Queries with Lots of Columns. We can reorder column Name with Drag and Drop or use Move in GUI to change the column’s order, but it is also possible to reorder via code. In this post, I will show how to Read more about Sort Column Name in Power Query via M Code[…]

How to set Workspace inside Azure ML SDK

Working With Azure ML workspace can be more flexible with Azure ML SDK. In this section, we are going to see how to set a workspace via AzureML SDK inside Notebook. in summary how to access the config file for the Azure ML workspace will be shown, and how to set a new workspace with Read more about How to set Workspace inside Azure ML SDK[…]

Market Basket Analysis in R Part 3

About a couple of years ago, I wrote two articles about what is association rules and how we can have them in Power BI.In this post, I am going to put some more enhancements and show you how with data that is not cleaned how you can create Market Basket Analysis. these enhancements are about Read more about Market Basket Analysis in R Part 3[…]

Azure Map in Power BI with Layers: Part Three

In the last two posts, I have explained how to access Azure Map and create bubble charts and Bar charts with other available settings. check the first Post from here and the second one from here. In this blog, I am going to talk about different layers we can have on top of the map. Read more about Azure Map in Power BI with Layers: Part Three[…]

Azure Map in Power BI: Part Two

In the last post, an introduction to Azure Map was presented. Azure Map has considerations and limitations as below( that may resolve later as now is in preview) You can use it in Power BI Desktop, Power BI Service, and mobile application But, not available Power BI publish to the web, Embedded and service embedding. Read more about Azure Map in Power BI: Part Two[…]

What is Azure Map in Power BI: Part One

Reza rad already wrote some articles about Map visuals in Power BI such as ArcGIS, Shape Map, and Filled Map. In this blog post, I am going to talk about Azure Map Visual in Power BI. a definition from Microsoft website: “The Azure Maps visual for Power BI provides a rich set of data visualizations Read more about What is Azure Map in Power BI: Part One[…]

Sync Slicers in Power BI

In some of the reports with many pages, some of the slicers are common, and all pages need to have them. Moreover, in some data analysis approach, we may want to apply one slicer, not on-page, but in all other pages in our reports. In this scenario, we need to use the sync slicers option Read more about Sync Slicers in Power BI[…]