After Installing the PowerShell Power BI Management cmdlets a few months back, I finally managed to get a dataset refresh working, initiated from PowerShell with a Service Principal. Yeej 🙂 But as you can imagine, it didn’t go without a fight (or 2, or maybe more), so I thought it would probably be good to share my… READ MORE
This article will guide you through the implementation of CI/CD pipelines using Azure DevOps. This will enable you to deploy your local report to your Power BI service automatically. To show you how it works, I will use an extension called Power BI Actions, available for free on the Visual Studio marketplace. Azure Portal Create a… READ MORE
I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here. I can’t tell you how many times I’ve started to work on a report I was told was working, only to find the connection info was invalid. This wastes valuable time, especially when you’ve already made… READ MORE
Join John P. White, MVP, TyGraph, Canada as he walks through what dataflows in Power BI are and in this instance, How To Build a Normal Report with Power BI.
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE
Currency conversion applied to BI reports can include many different scenarios. Data in multiple currencies, report with a single currency Data in multiple currencies, report with multiple currencies Data in a single currency, report with multiple currencies The rule of thumb is to apply the currency exchange conversion upfront. Therefore, it is a good idea… READ MORE
Early February we released an exciting new feature that enables you to add telemetry logging to your application using Application Insights. That blog post can be found here: https://powerapps.microsoft.com/en-us/blog/log-telemetry-for-your-apps-using-azure-application-insights/ This blog post is a walk through for getting that running specifically for creating a send a smile experience from your Power Apps. You can also find… READ MORE
In late January, Microsoft published the Power Platform: 2020 release wave 1 plan which lists all the new features that are targeting a release date before the end of 2020. The Power Platform ecosystem currently includes several different products that work reasonably well together and enable “users and organizations to analyze, act, and automate on the data to… READ MORE
This book introduces information workers, data analysts, IT pros, and developers to Microsoft Power BI — a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone. Access Chapter 1: Introducing Power BI here. Book contents: Get insights from popular cloud services on any device! Implement sophisticated personal BI models! Enable team… READ MORE
Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application. A video of these steps can be seen at: https://www.youtube.com/mspowerplatform Step 1. Create an app workspace to host the application. To do this: Log in to PowerBI.com and click on Workspaces > New Workspace. For people doing this at… READ MORE
