Designing a Star Schema for Power BI
The star schema is a cornerstone of dimensional data modeling and a standard design pattern in Power BI and other data warehousing tools. It simplifies data analysis and enhances query…
Power BI date
Power BI create date hierarchy manually (Arabic)
In this blog post we will learn how to change the language of the hierarchical date values in Power BI to display Arabic months. The first solution is to change…
Remove All spaces from string in PowerAutomate
When working with Power Automate, it's common to encounter scenarios where you need to manipulate text data—such as removing unwanted spaces—before further processing it. Whether you're concatenating fields or dealing…
processing Excel files uploaded to SharePoint
Power Automate how to check tables, verify columns,extract data from excel
Automating repetitive tasks can save time and reduce errors. One such task is processing Excel files uploaded to SharePoint. With Power Automate, you can automatically read an Excel file, verify…