• Home
  • Tools
    • Business Ops
    • Themes – New
    • Scrims
    • No Code – Custom Visuals
    • Layouts
    • Custom Visuals Gallery
    • Connections (PBIDS Files)
    • Model.JSON builder
    • ToolBox
    • Lingo
  • Recent
  • Shop
    • Power BI SWAG
    • Scrims
    • Layouts
    • Solutions
    • DAX Games
    • My account
      • Cart
      • Checkout
    • Terms of Use
      • General Privacy Rights
      • California Privacy Rights
      • Copyright DMCA Policy
  • Clothing
  • YouTube
  • More Resources
    • MBAS 2019
    • MBAS 2018
    • Videos
  • About
    • Owners
    • Contributors
News Ticker
  • [ 2021-01-05 ] Power BI End-to-End Architecture Sharing & Administration
  • [ 2020-12-22 ] Phil Seamark on Aggregation Tables Data Preparation Tips
  • [ 2020-12-16 ] Power BI Direct Query Composite Models = Amazing Power BI Developers
  • [ 2020-12-13 ] Power BI Architecture in a Data Solution Articles & Opinions
  • [ 2020-11-18 ] Building a Power BI Admin View using Power BI APIs Power BI Developers
HomeAuthorsSteve Campbell

Articles by Steve Campbell

Articles & Opinions

Power BI Architecture in a Data Solution

2020-12-13 Steve Campbell 1

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

Articles & Opinions

Power BI is part of the greater data solution

2020-10-23 Steve Campbell 1

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 […]

Sharing & Administration

Hot Swap Report Connections – External Tools

2020-08-13 Steve Campbell 16

A new external tools that allow you to switch from a live connection to directly connecting to an open Power BI report. […]

AnalyzeInExcel
Power BI Developers

Analyze in Excel – the Advanced Method

2020-07-22 Steve Campbell 1

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 […]

Sharing & Administration

Split an existing Power BI file into a model and report

2020-06-08 Steve Campbell 20

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

Sharing & Administration

Hot Swap Power BI Report Connections

2020-05-29 Steve Campbell 8

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 […]

Computer API Image
Data Sources

Power Query API Considerations

2020-02-10 Steve Campbell 2

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

Power Query Icon with Red X
Data Preparation Tips

Handle Errors in Data Refreshes with Power Automate

2020-01-16 Steve Campbell 5

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

Data Preparation Tips

Average Household Income Function in Power Query

2019-11-09 Steve Campbell 0

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 […]

Data Preparation Tips

Historical Stock Price Function in Power Query

2019-10-22 Steve Campbell 52

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

Posts navigation

1 2 »

Top Posts

  • Loading Excel Files from Sharepoint
    Loading Excel Files from Sharepoint
  • Dynamic Visuals using Buttons
    Dynamic Visuals using Buttons
  • Measures - Month to Month Percent Change
    Measures - Month to Month Percent Change
  • Icons upon Icons
    Icons upon Icons
  • Ranking Values with Measures
    Ranking Values with Measures
  • Creating A DAX Calendar
    Creating A DAX Calendar
  • Measures - Year Over Year Percent Change
    Measures - Year Over Year Percent Change
  • Loading Data From Folder
    Loading Data From Folder
  • Load Multiple Excel (xls or xlsx) Files
    Load Multiple Excel (xls or xlsx) Files
  • Measures - Dynamic Percent Change - Using DAX
    Measures - Dynamic Percent Change - Using DAX

Recent Posts

  • Power BI End-to-End Architecture
  • Phil Seamark on Aggregation Tables
  • Power BI Direct Query Composite Models = Amazing
  • Power BI Architecture in a Data Solution
  • Building a Power BI Admin View using Power BI APIs
  • Power BI Field Finder V2
  • Mirabile Notitia – Power BI with Harry Potter
  • Milwaukee Brew City PUG – Oct 2020
  • HTML Content Custom Visual
  • Power BI is part of the greater data solution
  • MVPs React October 2020
  • Customize the Default Dataset
  • Power BI Quiz – Themes
  • Milwaukee Brew City PUG – Sept 2020
  • MVPs React September 2020

Subscribe to our mailing list

Ads

Product categories

  • Game (7)
  • Layouts (22)
  • PBIX File (5)
  • Scrims (14)
  • Solution (3)
  • Uncategorized (0)

Tags

Advanced Advanced Editor Advanced Skill Level Bar Chart Beginner Beginner Skill Level Calendar CSV File Custom Layouts Custom Visuals Custom Visuals in Charts Data Modeling Dax DAX Calculate DAX Expressions DiscoverEI Excel Excel File Game Get Data ggplot2 How to Import Data from Excel Layouts mapbox Mapping Maps Measures Microsoft Milwaukee Brew City Monthly Releases MRAN Percent Change Power BI Power BI Desktop Power BI Embedded Power BI Tutorial PUG Query Settings R Slicer Tutorial Tutorials Using Data Models Videos

RSS Feed

  • RSS - Posts
Archives
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
Pages
  • About
    • Contributors
    • Owners
  • Home
  • More Resources
    • MBAS 2018
    • MBAS 2019
  • Recent
  • Shop
    • California Privacy Rights
    • Cart
    • Checkout
    • Copyright DMCA Policy
    • General Privacy Rights
    • My account
    • Terms of Use
  • Tools
    • Layouts
    • Lingo
    • Report Theme Generator V3
    • Scrims
    • Theme Generator
    • ToolBox
  • Top Tutorials
Categories
  • Articles & Opinions
  • Building Reports
  • Data Preparation Tips
  • Data Sources
  • Interesting & Fun Applications
  • News & Events
  • Performance Tips & Tricks
  • Power BI Developers
  • PowerBI.Tips Tools
  • Report Data Tips
  • Report Interactions
  • Report Visualization Tips
  • Sharing & Administration

Copyright © 2021 | MH Magazine WordPress Theme by MH Themes