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 [...]
I show how you can take a table that lists "Record" and expand that within Power BI. This also works with Power Query. I have a look at the M Syntax and show a cleaner approach.