Power BI Weekly
Issue #4 - 21st April 2019
It's been a relatively quiet week this week - the Power BI team has only one announcement for us: E-Mail Subscriptions for Paginated Reports is Now Available. Elsewhere, Brett Powell has provided instructions on how to generate some handy Power BI Admin Datasets, Erik Svensen describes how to E-mail the selected record in Power BI with Power Apps and flow and include a CSV File with the records and Adam Saxton solves a problem we've recently encountered here at endjin: Fixing a connection issue with Azure Databricks in Power BI.
🛠️ Data Prep
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2 and describes How to Use Dataflow to Make the Refresh of Power BI Solution FASTER
- Chris Webb (@cwebb_bi) writes about Power Query Memory Usage, Dataflow Container Size And Refresh Performance
- Marc Lelijveld (@MarcLelijveld) describes how to Pimp the dataflows connector in Power BI
- On myOnlineTraininghub, Mynda Treacy describes Power Query Approximate Match VLOOKUP
- Adam Saxton (@guyinacube) writes about Power BI Get Data: Import vs. DirectQuery vs. Live and describes Fixing a connection issue with Azure Databricks in Power BI
- On the Excelguru blog, Ken Puls (@kpuls) blogs about Creating a Fiscal Saturday Calendar
- Chandeep Chhabra (@chandeep2786) describes how to Separate numbers from text in Excel and Power Query
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) explains how to Combine or Append Data: Combining Flat Files
- Imke Feldmann (@TheBIccountant) describes How to get more out of your Graph API custom connector in Power BI, covers Query folding on JoinKind.Inner gotcha for Power BI and Power Query and writes about Easy way to retrieve Teams data in Power BI via Flow and other data from the Graph
🧩 Data Modeling
- Erik Svensen (@donsvensen) describes how to Move your pbix datamodel to Azure Analysis services
- Patrick Leblanc (@patrickdba) has A look at the Power BI Desktop Model View
- Eugene Meidinger (@sqlgene) discusses the DAX error: A function XXXX has been used in a True/False expression that is used as a table filter expression. This is not allowed.
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Aggregations in Power BI
⚙️ Report Design and Visualizations
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) walks through Using Dynamic Visuals On Ranking Based Parameters In Power BI
- On the MSSQLTips site, Scott Murray talks about the Power BI Key Influencer Visual
- On the DB Best blog, DeNisha Malone (@thepowerbiqueen) describes how to Sub-Divide and Segment Your Visuals — Episode 3
- David Eldersveld (@dataveld) explains how to Customize the Power BI Report Builder Map Gallery
- Matt Allington (@ExceleratorBI) explains how to Reposition Report Canvas in Power BI Desktop
- Michael McKinley writes Putting It All Together: Part 2
⚙️ Data Exploration
- Erik Svensen (@donsvensen) describes how to E-mail the selected record in Power BI with Power Apps and flow and include a CSV File with the records
🚀 Deployment, Security and Operations
- On the Power BI blog, Christopher Finlan (@cmfinlan) announces that E-Mail Subscriptions for Paginated Reports is Now Available
- Matt Allington (@ExceleratorBI) describes how to Scale your Power BI Capacity Up/Down
- Brett Powell (@BrettPowell76) talks about Power BI Admin Datasets
- Gilbert Quevauvilliers (@GilbertQue) covers Power BI Premium Performance – Part 1 | How to use the new XMLA End Point to see how much memory your datasets are using
🌐 General
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 96 - April 2019 Power BI Desktop Update & more news
- Adam Saxton (@guyinacube) talks about Power Platform, Power BI Paginated, new Power BI Desktop and more April 15, 2019