While working on Power Apps projects, I often had to move data from various sources, such as SharePoint lists, Excel files, and other systems, into Dataverse. Doing this manually every time was impractical, especially since the data needed to stay up to date. This is where Dataverse Dataflows became really useful. In this tutorial, we … read more…
SharePoint is a powerful collaboration platform that can change how your company manages documents, workflows, and team communication. But if you set it up poorly, it can quietly drain your budget through wasted storage, low productivity, and security headaches. Many mid-sized companies lose thousands every year because of simple mistakes that honestly could’ve been avoided. … read more…
When building apps in Power Apps, we often need fields to store simple true/false values, such as Is Active? Is it approved? Or has Email been Sent?. In Dataverse, this type of field is called a Yes/No field. In one of my apps, I needed a simple way to track things like whether a record … read more…
When I need to detect empty or missing values in a dataset, I use DAX functions in Power BI. In DAX, we have two functions, ISBLANK and ISEMPTY, and at first, they look like they do the same thing. Both functions return TRUE when something is empty and FALSE when data exists. Because of this, … read more…
When I was working on a Power Apps and Power Automate solution to create SharePoint sites automatically, I needed it to work across any tenant. The flow creates SharePoint sites via REST API calls, so we must pass the tenant name. However, Power Automate does not provide any direct action or function to get the tenant … read more…
I am working on a report for an organization, and I faced a requirement to identify and handle blank values in Power BI reports. Several columns contained empty data, which we did not want to consider in reports. Power BI provides multiple DAX functions, such as ISBLANK, COALESCE, FIRSTNONBLANK, and LASTNONBLANK, to identify, remove, or … read more…
One of my colleagues asked me how to join the First Name and Last Name columns in Power BI and add a space between them. He had tried creating a calculated column using the following DAX formula: However, this caused an error because the CONCATENATE function in DAX only accepts two arguments in the format … read more…
While working on a client report, there was a requirement to select multiple values from a slicer instead of choosing only one value at a time. The client wanted users to filter the report easily without holding the Ctrl key, and also needed the slicer to work across different visuals and tables. To solve this … read more…
While working on Power BI reports, I receive data from multiple tables or different data sources. Many times, the information we need is split across these tables, and using them separately can cause issues when creating table visuals in Power BI. To solve this problem, we need to merge tables in Power BI. We can … read more…
