Latest Enterprise DNA Initiatives

TIP: Tools and Techniques for Providing PBIX Files with Your Forum Questions

Forum Members,

All of us who answer questions on the forum strive to provide prompt, clear, specific and accurate solutions. However , what frequently holds us back from doing so is insufficient information provided in the initial post. A perfect initial question includes all of the following:

  1. A clear explanation of the problem you are experiencing
  2. A mockup of the results you want to achieve
  3. Your current work-in-progress PBIX file
  4. Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)

The one we typically have the most difficulty obtaining is the PBIX file, for a couple of reasons including:

  1. “My dataset is too large to send” - in this case, just try to reduce the data model down to only the the tables that are relevant for your question, and only a representative subset of records.

  2. “My dataset is confidential” – in this case you have two options, mask the actual data or create nonconfidential representative data.

The following video contains a number of simple techniques for masking names, dates and numbers in Power Query.

In terms of creating representative data, we have two tools that provide excellent options for you. The first is the EDNA Practice Dataset Tool, which creates a basic three year star schema dataset working backwards from today’s date, with a single Sales fact table, and a number of common dimension tables. The underlying dataset is also generated, and allows you to go into Power Query and transform the data and data model as needed to be representative of your situation.

The EDNA Practice Dataset external tool can be downloaded from this thread in the forum:

I also created the video below providing more detail on the installation and use of this tool. Note that to install this tool and most other PBI External Tools, you will need to have administrative rights to your machine.

Finally, if you need to create very specific data for it to be representative, we have recently provided another tool called Data Randomizer that allows you to create dummy data of very specific types and distributions.

It is available to download free in the Ultimate Power Bi Resource Pack on the portal.

Here’s a video on how use the Data Randomizer tool.

Given these options, you should be able to easily create a nonconfidential, representative dataset for nearly any question/scenario.

Doing so will help ensure you get the best possible support on the forum, and also will be greatly appreciated by those answering the questions and administering the forum.

Thanks very much, and feel free to give us a shout if you have any questions about the above.

– Brian

How To Mask Sensitive Data In Power BI
"Enter Data" Question
Add a Constant Line that is not date related to a visual
Data Source Error
Forecast Total Issue
Remaining Open tickets as of Date selection cumulative with Open on and closed on that date
Forecast Visual
Power Query Custom/Conditional Grouping
Cumulative of Sales when filtering by Month
Each transaction in my fact table has one quantity amount issued
Creating a Bookmark
Volume Share - allselected concept
Native Query Question - SQL
Access to data source in Power BI Service Issue
ALL EXCEPT doens't seem to work?
Conditional Formatting Above/Below The Avg Value
3YR Average by Month
Extended Date Table (Power Query M function)
Summation Error
Control blanks in hierarchy
DAX Combine Date Column and Time Column into DateTime Column
Frequency measure
Calculate workdays per month when start date is flexible
Convert Calculated Column to DAX Measure
Data Type Issue loading in Power Query
Input Field Churn
New/Dropped Accounts Logic Issue
QoQ Comparison Not Working For Last Date
Price Segments as a calculated table
QoQ Comparison Not Working For Last Date
% column in matrix
Distributing event duration to a row per each hour of its duration
Count as a Slicer
Dataflow Odata Connection Error
Accelerator 6 - Has it started?
What if parameters working selectively
Tracking Concurrent Calls in Call Center
Budget data contains specific Customer records and also an all other record for smaller Customers
Leadership Consistency- calculations with multiple dates
Get Data from an Rest API with Odata.Feed and Api Key
Text analysis: count of hashtags and number of words in a column
Super slow formula when evaluating against date table
Previous Month Totals from MAX Date
Max(Date[Date]) measure used in the filter function
Formatting Time and doing further calculations
Sales by Regional & National Avg
How to Successfully Implement a Piece of M Code
Measure showing wildly different values in chart than in table
Slicer to see the running total value for specific filter selection
Switch True Logic with dates
New to Edna need help
R12 Data This year and last year
Getting the average of Latest 12 weeks
Access the Available Hours and bring accross to Tktable to calculate a measure!
Epicor ERP and PowerBI
ROLLUP change true/false to be more meaningful
Financial Statement Bold Row
R12 Data This year and last year
DAX formula to accomodate both by Weekending Period Slicing and by Month&Year Slicing
Grand Totals Not appearing without stepped layout enabled
Time intelligence Measures
Compare to periods Without Time Intelligence Function
Date Table Filter Not Working on New Data Source
Date Table Filter Not Working on New Data Source
How to include budget data in the income statement template shown in the financial reporting module?
Ratio in Sales and hours
Bring a value from table

Marked as solved.

Hi all,

One more trick to add to this great resource posted by @BrianJ

If you have small sample tables that don’t exceed a 3.000 cell limit across both columns and rows, you can copy and paste them directly into the “Enter Data” window. That way you don’t have to supply a separate data file along with your PBIX. :wink:

1 Like