Convert Matrix data in Excel to Tabular Data in Power BI.

There is a common way of seeing data in Excel as a Matrix format; many data entries look like a matrix in many contexts, from accounting to health data. However, to better analyze data and add more calculations and charts and, in general, get more insight from data, we need to change the matrix data Read more about Convert Matrix data in Excel to Tabular Data in Power BI.[…]

Power BI and Excel; More than just an Integration

Power BI and Excel are longtime friends of each other, not only because Power BI components come from add-ins introduced in Excel but also because of how these two tools interact with each other from the Power BI Service. This post is not about using Power Query or Power Pivot components in Excel. This article Read more about Power BI and Excel; More than just an Integration[…]

Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)

Here I will share one of my business case scenario using Power automate, Excel and OneDrive for a conference management that can be apply to all other training class scenarios.we normally want to create a personalized folder for your students in class or for our speakers in a conference so they/we can put or files Read more about Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)[…]

Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamically

Combining multiple files from one folder is already supported built-in through the graphical interface of Power Query when use you Get Data from Folder. However, if you have one Excel file, with multiple sheets with the same structure but different data, you cannot use that option. There is a very little but useful trick that Read more about Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamically[…]

Say No to Export Data, Yes to Analyze in Excel: Power BI and Excel Can Talk!

Despite the fact that I have explained about the Analyze in Excel feature in Power BI before, still, I hear and see many users are using the Export data option in Power BI much more. In this post, I am explaining what is the difference and why it is better to use Analyze in Excel Read more about Say No to Export Data, Yes to Analyze in Excel: Power BI and Excel Can Talk![…]

Creating a Table in Power BI Using DAX Table Constructor

There are some functions in DAX that are useful in very specific scenarios. For example, sometimes, you might want to create a table entirely in DAX. If you want to do that, what are your ways and how it is possible? This might be helpful especially in the first days of learning about DAX. Let’s Read more about Creating a Table in Power BI Using DAX Table Constructor[…]

Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure

One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. Read more about Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure[…]

Azure Machine Learning Part 2: Azure ML Environment

In the previous post, the main concepts of Machine Learning has been explained very briefly. However, if we want to talk about Machine Learning, it needs to read a whole book. In the second part, I am going to show the main Azure ML environment and its essential components. Azure ML has two type of Read more about Azure Machine Learning Part 2: Azure ML Environment[…]

Data Preparation is the Keystone – Free Webinar

Join me to learn about Data Preparation with Power Query and Power BI. This free webinar hosted by Power BI team and I will speak about techniques in Power Query that helps you transform the data and prepare it in the way required for your business. Expect many demos in this session from Power Query Read more about Data Preparation is the Keystone – Free Webinar[…]

Export Data Starting From Special Cell in Excell File – SSIS

Sometimes you have a formated Excel file, which you want to use this file as Destination, so you may need to import data start from special Cell inside the excel file.By default SSIS import data from Column1 and Row1 in excel file. But you can change it. Solution: Suppose this excel format: in this sample Read more about Export Data Starting From Special Cell in Excell File – SSIS[…]