This article will focus on Power BI architecture within a data solution. This
Power BI architecture describes how Power BI can slot in as a piece of this strategy. Next, it discusses different Roles and Responsibilities involved. […]
Power BI is a powerful reporting tool that has been dominating the market and rapidly evolving. Yet, in many organizations people seem unaware of its true potential or core purpose. As a result, too often […]
A new external tools that allow you to switch from a live connection to directly connecting to an open Power BI report. […]
A common ask from users is the ability to view data related to visuals in excel. While there is an option to export data, the format is often unfriendly and has limitations. What’s more, this […]
This post describes how to split a pbix into a model and report file using a PowerShell Script. This means any report can quickly be split into a data model file and live connection report file. […]
Let’s say you have a Power BI file connected to an Analysis Services machine. Then you want to change the data source to PowerBI.com using a Live Connection. Well, you are out of luck. Until […]
This article is the second part in a series on API calls. It will look at some best practices and considerations when using API calls in Power Query. […]
This article examines using the advanced editor in Power Query to better handle when things go wrong. It will also allow custom actions to be triggered using Power Automate, allowing the rest of the data to be refreshed while alerting the owner by email of data source errors. […]
This post will walk through how to pull an estimated household income from a US address. It will be completed all in the Power Query Editor. We will convert this to a function to reuse […]
This post will walk through how to pull daily stock price from Yahoo! Finance, then transform the data using a technique called a query branch. It will be completed all in the Power Query Editor. […]
Copyright © 2021 | MH Magazine WordPress Theme by MH Themes