Power BI Quiz (Test Prep for Certification) (@rsaprano) The definitive guide to ALLSELECTED (@FerrariAlberto) Share reports with your teams and partners Connect to tens of thousands of datasets on data.world with the new connector for Power BI Desktop Power BI Desktop February Feature Summary BONUS ITEMS: Joining tables In Power BI using Power Query and/or [...]
Power Query – Consecutive Days (@PowerPivotPro) The Each Keyword in Power Query (@kpuls) Remove repeating characters from a string in Power BI and Power Query (@TheBIccountant) "In the Previous" Date Filters In Power BI/Get&Transform/Power Query (@cwebb_bi) Query folding to improve Power BI performance (@CurbalEN) Power BI Desktop January Feature Summary BONUS ITEMS: Adding Comments & [...]
In this video, Patrick builds on a blog post from Scott Senkeresty to dynamically change the axis of your visual within Power BI. This uses a combination of Power Query and DAX. Chris Cook - @Finalyst89 Scott Senkeresty – @ScottSenkeresty Dynamically changing chart axis http://tinylizard.com/dynamically-changing-chart-axis/
In this video, Adam looks at how to use conditional columns within Power Query and then copying them for use in other queries or Power BI Desktop files. This is a great technique if you don't want to retype all of the conditional items in the dialog in Power BI.
Exploring The New SSRS 2017 API In Power BI (@technitrain) Bulk-extracting Power Query M-code from multiple pbix files in Power BI (@TheBIccountant) Automatic installs of Power BI Desktop (@CurbalEN) How administrators can manage the Power BI Desktop sign-in form Visualizing and interacting with your Azure Machine Learning Studio experiments Congratulations to the Winners of the [...]
Pivot your Data using Power Query (@Datatouille) Analyzing a Blockchain Database with Power BI – Introducing SteemitSQL (@TheExcelClub) Visualizing Merge Join Types in Power BI (@SQLJason) Power BI Service and Mobile July Feature Summary PowerApps and Power BI, together at last BONUS ITEMS: New function and the importance of variables in #dax (@marcorus) DYNAMICALLY UPDATE [...]
Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implications (@technitrain) SSAS TABULAR VS MULTIDIMENSIONAL FEATURE MATRIX (@BrettPowell76) Reusing Datasets Imported to the Power BI Service (@SQLChick) Power BI Report Server preview now available What’s new in SQL Server 2017 CTP 2.1 for Analysis Services BONUS ITEMS: How to compute index numbers at top [...]
Web.Contents(), Caching And The ExcludedFromCacheKey Option In Power BI And Power Query (@technitrain) Extract Tabular Data From Power BI Service to Excel (@ExceleratorBI) Power BI Desktop January Feature Summary Embedding a Power BI report into Salesforce Power BI mobile phone reports now available everywhere BONUS: Power BI Desktop – 2016 Year in Review Using Power [...]
A post on how to use Power Query to audit file changes. A look at KPIs within Power BI. Keeping up to date with Azure Active Directory Connect. And a post about how to use custom thumbnails for mobile reports in Reporting Services 2016. Power Query as a File Audit Tool (@ExceleratorBI) KPIs and Power [...]
In this roundup, Reza Rad talks about relationships with multiple columns, Chris Webb talks about timing execution of M queries, we have some updates for the Power BI service, a look at Power BI embedded within your custom applications and something free for you! Relationship in Power BI with Multiple Columns (@Rad_Reza) Timing M Query [...]
