Category Archives: Power BI
Gain Business Insights faster by generating Power BI Reports quickly with just 1 click in Dataverse
Hi All, I’m going to show a useful feature that you can leverage to view and create instant Power BI visuals that is generated automatically based on the current view. Documentation Link Just an example: How it looks Steps to achieve this: Step 1: You need to enable this feature in Model-Driven App itself Edit … Continue reading Gain Business Insights faster by generating Power BI Reports quickly with just 1 click in Dataverse
Share Story :
Download SSRS report as a PDF with Power Automate – Part 2
In this blog, we will see how to extract the value for PdfDownloadUrl so we can load it into another request and get our PDF.
Share Story :
Download SSRS report as a PDF with Power Automate – Part 1
In this blog, we will see how to retrieve PDF Download URL from the console using the SSRS report. Step 1 – Create a new flow and set the trigger to Manually trigger a flow. Step 2 – After you have your trigger, you need to add two inputs to it, Report Name and Report XML. Step 3 … Continue reading Download SSRS report as a PDF with Power Automate – Part 1
Share Story :
Using the Power BI Report Builder to create and publish paginated reports.
Power BI Report Builder is a great tool to create paginated reports which can be easily printed in a proper page layout. If you used to work in SSRS Report Builder, the whole environment will look familiar. Plus Power BI report builder is a very light tool and has additional features such as directly importing … Continue reading Using the Power BI Report Builder to create and publish paginated reports.
Share Story :
How to create Date table using M query
You Might have seen the other ways to create the DateTable in Power BI using m query by adding two Custom columns such as startdate and enddate and then using DateRange function you can populate the dates between startdate and enddate However, in this blog, we will see the M query that enables you to … Continue reading How to create Date table using M query
Share Story :
Full Outer join Using DAX in Power BI
Thinking of full outer join in Power BI what comes first in your mind? How can we achieve full outer join in Power BI? Common Answer will be the “Use Merge Query” Option in Power Query Window. However, I would like to tell you that we can use DAX to achieve Full Outer Join. Full … Continue reading Full Outer join Using DAX in Power BI
Share Story :
Display Horizontal Page tab in Power BI web
In Power BI Desktop app and when we edit the report on Power BI workspace, page tab visible at bottom, but when we publish the report on to the Power BI Service then it is visible on left side. We can change the Tab Position in the Power BI web as well, to do that … Continue reading Display Horizontal Page tab in Power BI web
Share Story :
Export Power BI data to CSV via Power Automate visual and upload to SharePoint
After PowerAutomate was added in PowerBI as a preview feature, it is finally available for general use. In this blog we are going to use this PowerAutomate visual to export PowerBI data into CSV and upload the CSV on Sharepoint. Open PowerBI Desktop and drag the PowerAutomate Visual, if it isn’t available in the visualization … Continue reading Export Power BI data to CSV via Power Automate visual and upload to SharePoint
Share Story :
Add rows to Power BI dataset for date range
Hi in this blog we will see how we can add rows to power bi dataset for a given date range. For example if you have a dataset which has start and end date and you want rows for each date between this range then this blog will help you. Step 1: Open Power BI … Continue reading Add rows to Power BI dataset for date range
Share Story :
How to list all dates between two dates in PowerBI and distribute numbers evenly among them.
Consider a scenario where a start and end date along with the total duration for a particular task has been given to us. We have to distribute the total duration equally among all dates between the start and end date. We can solve this issue by the combination of Power Query and DAX. Lets see … Continue reading How to list all dates between two dates in PowerBI and distribute numbers evenly among them.