Microsoft Dynamics Business Central as a Data Type in Excel via Power BI

January 20, 2022 / Belinda Allen / Leave a comment

While hosting yesterday’s Power Platform Mix it up with New View Strategies, Microsoft Senior Program Manager Bl azej Kotelko talked about using Microsoft Dynamics Business Central Data, specifically a dataset in Microsoft Power BI as a source for Data Types in Excel. Several of us hung out yesterday and tried to do it. We thought we missed something because it wasn’t working. Today though, I noticed it appeared and it works! My mind is blown!!!! Watch the end results.

The “How this is done” video will come soon. Thanks to the friends that hung out with me and worked on this:

Po wer Platform Mix It Up is a community meetup focused on all things Microsoft Power Platform using Microsoft Dynamics 365 Business Central.

Copy Value/Table from Microsoft Power BI Report

April 23, 2021 / Belinda Allen / 1 Comment

Do you ever wish you could copy a value or a table in a Microsoft Power BI Report? Well, you can! Watch Belinda show you just how simple it is!

Organizing Data with Folders in Microsoft Power BI

April 19, 2021 / Belinda Allen / Leave a comment

Sometimes a query in Microsoft Power BI will have so many fields that it is cumbersome. In this Tiny Tip, I will show you how to use folders to organize the query, making it easier to find the fields.

Removing Duplicate Records in the Microsoft Power BI Query Editor

April 16, 2021April 12, 2021 / Belinda Allen / 1 Comment

In this Tiny Tip, I will show you how to remove and check for duplicate records in the Microsoft Power BI Query Editor. In my example, I am pulling customer information from a Sales table. Hopefully, I am invoicing (or selling to) customers more than one time. Check out this tiny video on how I verify my data (aka repeat business).

Referencing a Query in the Microsoft Power BI Query Editor

April 14, 2021April 12, 2021 / Belinda Allen / Leave a comment

In this Tiny Tip, I will show you how to break up a big flat query in the Microsoft Power BI Query Editor using Reference. This will prevent you from having to import the same data into your data model multiple times.

Importing data from a CSV Download into Microsoft Power BI

October 2, 2020September 23, 2020 / Belinda Allen / 1 Comment

What if your Microsoft Power BI report needs to access data from a website, but the only option is a CSV download? In this tiny tip, Belinda will show you how to make a CSV download act like an API.

More SEC Football data modeling in Microsoft Power BI Query Editor

September 30, 2020September 23, 2020 / Belinda Allen / 1 Comment

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 a Custom Table in the Microsoft Power BI Query Editor

September 29, 2020September 23, 2020 / Belinda Allen / 1 Comment

As I continue building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC); I will show you how I created a custom static table of the 14 teams in the SEC.

Creating Data Parameters with Suggested Values in Microsoft Power BI

September 21, 2020September 18, 2020 / Belinda Allen / 1 Comment

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

September 17, 2020 / Belinda Allen / 2 Comments

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.

	Show Value for the L… on Show Value for the Last Date i…
	More Matrix (visual)… on More Matrix (visual) formattin…
	Using Small Multiple… on Using Small Multiples in Micro…
	Matrix (visual) tota… on Matrix (visual) totals and sub…
	Using an Inserted Sh… on Using an Inserted Shape as a N…

Bits and pieces from the world of Business Intelligence by Belinda Allen

You cannot improve what you do not measure.

Data