When I am working on, building and/or designing my Microsoft Power BI reports, I go back and forth between my desktop PC and my notebook. If my data source is a local file, like an Excel file, it can be tricky. Tricky, that is, if you do not use parameters for the file path. I use this feature now, EVERY time I work with local data. Saves me oodles of time and frustration! Check it out!
More SEC Football data modeling in Microsoft Power BI Query Editor
In this tiny tip, I show you more Data Modeling I performed on my US College (American) Football South Eastern Conference (SEC) Microsoft Power BI Report. I show how I incorporate parameters with my data and I create a custom title for my report.
Creating Data Parameters with Suggested Values in Microsoft Power BI
I have shown you already how to create parameters with SQL Server data in Microsoft Power BI. This time, I am going to show how to use a suggested list, so rather than manually entering data, I can select my parameter from a dropdown list. By the way, if you are a US College (American) football fan, you will be excited about the report that is being built!
Creating data source parameters for SQL Server in Microsoft Power BI
If you want to model data against a development SQL Server environment and deploy against a production SQL Server, in Microsoft Power BI, this video is for you. In this Tiny tip, I will show you how to create a Parameter, edit your data source, export, and import your work.