Category Archives: Power BI

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 :

Hide and show slicer pane with a toggle button

Posted On April 22, 2021 by Jaison Menezes Posted in

Sometimes we would want to toggle some visuals in PowerBI on the basis of a button click for instance when clicking a button a certain visual shows up and while clicking the same or another button the visual hides itself. This can be easily done with the help of bookmarks in PowerBI. In this blog … Continue reading Hide and show slicer pane with a toggle button

Share Story :

Use Microsoft Forms with Power BI Reports

Posted On April 3, 2021 by Jaison Menezes Posted in Tagged in ,

Sometimes we would want to ask users about their thoughts , opinions or ask some questions along with a PowerBI report. That is, we would need  to collect information about the user through PowerBI App.  This can be done by creating a Microsoft Form inside PowerBI interface to collect user information. This can be demonstrated … Continue reading Use Microsoft Forms with Power BI Reports

Share Story :

How to solve OLE DB or ODBC errors in PowerBI

Introduction: Sometimes while refreshing our dataset in PowerBI or importing new data from existing sources we may encounter OLE DB or ODBC errors as shown in the image below. This might be due to caching issues. To solve this follow the steps: Go to File tab on the ribbon in PowerBI Desktop , then click … Continue reading How to solve OLE DB or ODBC errors in PowerBI

Share Story :

Securing an API using OAuth 2.0 in Azure API Management Part 4

Part 4: Testing using Developer Portal and JWT Policy Configuration Introduction Configuring OAuth 2.0 for your APIs hosted in Azure API Management adds an extra layer of security and prevents unauthorized access. This is a very important configuration form Security point of view for your Endpoints and is provided out of the box by Azure. … Continue reading Securing an API using OAuth 2.0 in Azure API Management Part 4

Share Story :

Securing an API using OAuth 2.0 in Azure API Management Part 2

Part 2: Configuration of an Application (Client App) in Azure AD for Consumer Introduction Configuring OAuth 2.0 for your APIs hosted in Azure API Management adds an extra layer of security and prevents unauthorized access. This is a very important configuration form Security point of view for your Endpoints and is provided out of the … Continue reading Securing an API using OAuth 2.0 in Azure API Management Part 2

Share Story :

Securing an API using OAuth 2.0 in Azure API Management

Part 1: Configuration of Applications in Azure AD Introduction Configuring OAuth 2.0 for your APIs hosted in Azure API Management adds an extra layer of security and prevents unauthorized access. This is a very important configuration form Security point of view for your Endpoints and is provided out of the box by Azure. This is … Continue reading Securing an API using OAuth 2.0 in Azure API Management

Share Story :