This is a collection of tips and getting started guides for people new to Power BI

Before You Start

• Power BI Desktop is the tool you use to develop and create reports. It is only available for Windows.

  Open

  

• Power BI Desktop reports can be published to the Web where they can be viewed in a browser, Microsoft Teams, or mobile. Published reports have multiple ways they can refresh their data.

• Install Power BI from the Microsoft Store, this ensures your Power BI installation is always up to date.  (You may need to disconnect from the VPN to use the Microsoft Store - Microsoft Store & VPN bug)

• Power BI allows you to securely share reports and the associated Data Models with any other Geneseo user.

• Power BI can work on Millions of rows of data very easily (with a proper data model) and can even work against 100s of million row datasets.

Accessing Your Data

Power BI can access Data in 3 ways. Here is a nice video overview if you prefer.

1. It imports it.
   This is default way Power BI likes to work with your data and the way you most often will work with data. Power BI supports over 300 data sources. 

2. Direct Query. 
   In this method the data stays in the source system. You can query directly against a file or database or any of the other supported Power BI data source. This method can be slow unless the data source you are reporting against has been setup in a good data model for reporting. It also can require a gateway connection be setup by your administrators so the data can be accessed by reports running in the Power BI cloud service. You also will have trouble supporting calculated fields using DAX with this method.

3. Composite Mode. This method mixes Direct Query and Import data modes. This allows more flexibility 

One of the easiest ways to get data into Power BI is to load it from a CSV or Excel file, you can even point it at a file on your OneDrive or Microsoft Team and it can update whenever you update the data in that file. Once you do that you will be able to manipulate it into a good data model and then you can begin reporting against it. If your file is in OneDrive or SharePoint it makes refreshing the data extremely easy.

Note that with the default Import option where Power BI is importing the data there are built in ways to have your data refresh on a schedule so a dashboard can be kept up to date with the latest data.

Star Schemas and Data Models

Star schemas are a well known way of laying out data for reporting purposes. Microsoft covers them well in their document on them. This video "The Perfect Data Model for Power BI - Creating a STAR SCHEMA from a Flat File / Excel Table source!" is an awesome overview of going from a single table flat file data import to a star schema and why you would want to go through the effort of doing so. Also check out Flat file to data model, Data modeling best practices - Part 1 - in Power BI and Analysis Services and Where to create your columns in Power BI | Data Modeling Best Practices

It's important to put time into your data model, if you do your reports will become a lot easier!

Training Notes

• Overview of Data Analytics: https://docs.microsoft.com/en-us/learn/modules/data-analytics-microsoft

• Microsoft Documentation:

  • Power BI Documentation: https://docs.microsoft.com/en-us/power-bi/

  • Learning Power BI: https://powerbi.microsoft.com/en-us/learning/

  • Power BI Webinar: https://docs.microsoft.com/en-us/power-bi/fundamentals/webinars

  • Power BI Getting Started: https://docs.microsoft.com/en-us/learn/modules/get-started-with-power-bi

• Data may be either imported or sync'd from other sources: https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand

• The DAX language provides many functions for manipulating data: https://docs.microsoft.com/en-us/dax/

• Some other videos on Power BI topics that are very good

  • Guy in a Cube YouTube Channel - This channel has a ton of great videos covering all kinds of tips and tricks of working with Power BI

  • Create your first Power Bi Report (2021)

  • Create a Power BI streaming dataset for real-time dashboards

  • Handling Multiple Fact Tables in Power BI

  • Do these 5 things before publishing your Power BI report

  • Columns from examples- A really cool way to transform your data VERY simply using the AI built into the Power Platform.

Related articles