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.

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.

Renaming and Hiding Fields in Microsoft Power BI

Microsoft Power BI allows for the hiding of fields in Report Mode.    In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX.

Tiny Tips

Microsoft Power BI allows for the hiding of fields in Report Mode.    In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX.

Today’s DAX Expression:

Customer and Class = 
Customers[Customer Name] & " " & Customers[Customer Class]

Setting Geographic Data Categories in Microsoft Power BI Q&A

Ever use a map visual in Microsoft Power BI, but the locations are not correct?  In this Tiny Tip I will show you how to categorize geographic fields.  For example, we will take the city field and define it as a City.  If you were trying to display information for the city of New York, Texas, you would not want it to display as the state of New York. 

Tiny Tips

Ever use a map visual in Microsoft Power BI, but the locations are not correct?  In this Tiny Tip I will show you how to categorize geographic fields.  For example, we will take the city field and define it as a City.  If you were trying to display information for the city of New York, Texas, you would not want it to display as the state of New York.

Adding the Last Refresh Date in Microsoft Power BI (Tiny Tip)

In this TINY Video, I will add the last date and time the data in Microsoft Power BI was refreshed.  Old data is bad data!  This is an easy way to make sure you are looking at a good data!

Tiny Tips
by @MsBelindaAllen

 

In this TINY Video, I will add the last date and time the data in Microsoft Power BI was refreshed.  Old data is bad data!  This is an easy way to make sure you are looking at a good data!