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 […]
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. […]
This post will answer how to sort a measure that returns text values to a custom order, without affecting other columns. It will utilize the […]
Sometimes, we want the users to see different metrics, but do not want to take up too much space on our page. The scenario we […]
Copyright © 2020 | WordPress Theme by MH Themes