Category Archives: Power BI

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

Posted On December 13, 2021 by Yogesh Gunjal Posted in Tagged in ,

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

Posted On October 17, 2021 by Aditya Somwanshi Posted in Tagged in

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.

Posted On August 2, 2021 by Jaison Menezes Posted in Tagged in , ,

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.

Share Story :

Delete multiple tables or columns at once in PowerBI

Posted On May 4, 2021 by Jaison Menezes Posted in Tagged in

While importing data into PowerBI we can choose the tables we want to load in the data model but we cant choose specific columns, although columns can be removed through advanced editor or by manually deleting them one by one this can also be done without using advance editor and multiple columns or tables can … Continue reading Delete multiple tables or columns at once in PowerBI

Share Story :