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 […]
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 […]
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 […]
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 […]
“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 […]
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 […]
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 […]
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 […]
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. […]
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. […]
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!
