I am not sure how I missed the ability to copy Power Queries and/or Folders between PBIX files in Power BI. Most users are aware of the template capabilities of Power BI – you can create a Power BI model, export the model as a template, and use the template for new solutions. In some … Read more
Power BI Training? My most common request, by far, is for training resources for Power BI. There have been some posts I have used to acquire more/better/different options for learning Power BI but I have accumulated, filtered out, and singled out the best resources below. I will add/modify periodically as new resources are added and … Read more
An overview to the top Microsoft Business Intelligence Roadmap Enhancements announced thus far for Power BI Services and Mobile, Microsoft Excel 2016, SQL Server Reporting Services 2016, and SQL Server Analysis Services 2014-2016. I will not be the first to say this (I will be added to a long list of others), but SQL 2014 … Read more
Before a Power View report can be built, you have to have a data model built as a data source. There are several configuration options to help optimize your data model specifically for Power View. These configurations and/or optimizations are made within your Power Pivot model or in SQL Server Data Tools on the SSAS … Read more
DAX Best Practices are vital when utilizing large data models and looking to improve performance. You can get away with poor practices on small models but you will see performance issues as your data grows. Data Analysis Expressions (DAX) is the native query and formula language for Microsoft Power Pivot data models and SQL Server Analysis … Read more