Power BI Weekly Issue 4: 23rd 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
Covering: Power Query (M), Dataflows, Data connectors
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- 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
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- 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
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- 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
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.