Happy Thursday! This week we’re getting a little fancy with Power BI and learning how to easily change a data source.
It’s *really* easy to break a Power BI report by changing a data source, but it’s also really easy to avoid this breakage once we start understanding what Power BI does “behind the curtain” when it connects to and reads a data source.
We can make ONE report that can have infinite versions easily with a simple data source switch.
Learn how here:
Next Week: SUMX
Last week we got started with a little bit of DAX learning and figured out how the SUM function works. Next week we’re having a look at SUMX.
While SUM adds up a column of data, SUMX adds up a row, which can be super useful in calculations and making a more efficient data model.
We’ll talk all about it next week. You’ll love it. :)
From the Archives:
You can always check out the How To Use Power BI Archives (they’re free too). Our archives feature this week is related to connecting data sources too. It’s a beginner post about how to connect to Excel data in the first place!
Take care everyone,
Joe.
Contact me, Joe Travers, at Travers Data or at joe@traversdata.com. I got you.