Forum Discussion

Brett Powell's avatar
Brett Powell
Copper Contributor
Oct 08, 2016

Sample Power Pivot and Power BI Desktop Models

Hi,

 

I've recently built and published two sample data models - one with Power Pivot for Excel and another with Power BI Desktop to support training and testing of model and report authoring features in both tools (e.g. DAX metrics, chart/visual types).

 

Both models use the https://msdn.microsoft.com/library/mt734199(v=sql.1).aspx sample data warehouse database for SQL Server 2016 as the source and they share the same schema and metadata. Each can be downloaded from the following two links:

 

http://tinyurl.com/z2gyhps

 

https://insightsquest.com/2016/10/08/sample-power-bi-desktop-model-available-for-download/

 

The models contain multiple star schemas so they may be a bit larger than common XLSX and PBIX models but this also makes them more powerful and useful for learning and understanding evaluation context.

 

I hope these can be of value but please feel welcome to comment here or on my blog if you have problems or issues. Isn't it great that we TWO great BI tools like this?

 

-Brett

No RepliesBe the first to reply

Resources