Power BI – Input Google BigQuery Native Queries directly

Google Bigquery connector now supports native database queries similar to SQL connector. Now we can build a query and create reports on top of it which was limited in earlier version of the connector.  Below is the step-by-step procedure for the same. Open Power BI Desktop – Go to Get Data – Select Google

Calculate Running/Cumulative Totals using PARTITION BY Clause

Running or cumulative total is a sum of a sequence of numbers that gets updated each time a new number is added. The sequence is generally sorted by a date value. We often come across scenarios where we are required to calculate running or cumulative totals or average. In this post I will show you

Analyze Power BI App, Reports and Dashboards in Microsoft Teams

Now you can view your Power BI Apps, reports and dashboards directly from your Microsoft Teams. Steps Microsoft Teams Login to Microsoft Teams Open Apps Click More Added Apps below Files icon Select More apps Find Power BI App Search power bi inside the search bar Find and select Power BI app Add Power BI

Manage Power BI user Permissions/Access easily using Microsoft Teams

Prerequisites Microsoft Teams Azure Subscription Power BI Steps Create a team on Microsoft Teams. Click the link to learn on how to create one on Microsoft Teams. Add members to this Microsoft Teams who are supposed to be grouped to have access to a Power BI report or Power BI Workspace. Get your team’s email