Skip to content
Logo
  • About Us
April 12, 2021

Azure Function to combine PDF files saved in Azure Storage Account (Blob container)

We will create an Azure Function that will merge PDF documents stored in a container of our storage account in Azure, this function will receive the file names to be merged/combined in the parameters of the URL and they will […]

Graciela Martinez Azure 0 3 min read
March 31, 2021

Active Directory OAuth in Power Automate: How to set up Certificate Credential Type

Client secret credential type is straight forward in Power Automate, you only need to grab the secret value, paste it in the right field and you are good to go! For Certificate credentials, you need an additional step for the […]

Graciela Martinez Power Automate 2 1 min read
March 21, 2021

Power Automate Desktop: now available at no additional cost.

In the last days Microsoft announced that Power Automate Desktop is now available for all Windows 10 users at no cost, regardless if the user has an Office365 subscription or not. In their efforts of “democratizing” automation they have opened […]

Graciela Martinez Power Automate 0 1 min read
February 24, 2021

Power Automate Desktop: Download files from the web using Chrome, Firefox or Edge

Power Automate has evolved a lot in the recent months, and with their Desktop application they have expanded the possibilities of automation. However, it has limitations when it comes to download files from the web, still, Microsoft offers a way […]

Graciela Martinez Power Automate 4 2 min read
October 29, 2020

Power BI Smart Narratives: Game Changing Feature?

“In a world in which the data is changing all the time, writing executives summaries is not very practical” Arun Ulagaratchagan| Microsoft’s Corporate Vice President Intelligent Platform It is clear that Microsoft is committed to automating as much manual tasks […]

Irvin Barrera Power BI 0 2 min read
September 20, 2020

Visual of the week: Histograms | Book Ratings

Histograms are a great way to explore data and to see how it’s distributed among different dimensions.  Today we will be looking at book ratings data to try to answer a couple of questions using Power BI visualizations. Book-Crossing Dataset […]

Irvin Barrera Power BI 0 3 min read
June 6, 2020

Parameter table with DAX: Create a slicer to change amounts to millions & thousands

Suppose we have a table with a measure such as Sum of sales amount, and we would like to give the user the ability to change the way the amounts are shown, using a slicer. The blue slicer in above […]

Irvin Barrera DAX 0 1 min read
May 17, 2020

Dynamic SQL queries with Excel’s Power Query

Use an excel table to modify your SQL query If you regularly run queries to any database in your workplace, chances are you have encountered a user request like this: We can use Excel to query the database and get […]

Graciela Martinez Power Query 2 3 min read
April 19, 2020

Combine Files With Slightly Different Columns (Advanced Solution)

When we connect to a folder to combine all the files, Power Query creates a “Query” called Sample File, which is used as example to process each file, the results will depend on the columns that exist in this file. […]

Graciela Martinez Power Query 0 2 min read
April 5, 2020

Power Query Files from Folder: Make the Sample File the One With the Most Columns

When we connect to a folder to combine all the files, Power Query creates a “Query” called “Sample File”, which is used as example to process each file, the results will depend on the columns that exist in this file. […]

Graciela Martinez Power Query 4 1 min read

Posts navigation

1 2 »

Search

Categories

  • Azure (1)
  • DAX (2)
  • Power Automate (3)
  • Power BI (2)
  • Power Query (4)

let us help!

We are confident you’ll find something interesting that can save you time or solve that business problem nobody is addressing at the office, become the hero!

If you are having a hard time with a particular problem, send it to us, we love challenges and being able to help, email us at contact@powergi.net, also looking forward to hear any questions, recommendations or corrections you all may have. Thanks!

Archives

  • April 2021
  • March 2021
  • February 2021
  • October 2020
  • September 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • About Us

Copyright ©2021 Welcome to Power[GI] . All rights reserved. Powered by WordPress & Designed by Cyclone Themes