Power BI Weekly Issue 207: 16th May 2023
It's one week until Microsoft Build, so if you haven't already, register for free on the Build website - you don't want to miss it. There's been a bit of a lull in articles this week in the lead up to the conference, but we have been given one announcement, which is Better Power BI Report Integration with OneDrive and SharePoint (Preview), which provides the ability to explore and interact with Power BI reports directly within OneDrive/SharePoint, and browse and open OneDrive/SharePoint items directly within Power BI Desktop (just like other Office tools). Very useful features. I agree with the first comment though - the game changer will be when business users are able to collaborate on pbix files in a robust way - hopefully that's not too far on the horizon. Elsewhere, there's been a couple of handy videos from the GuyInACube folks - namely, Mara Pereira has joined Adam to share some tips about how to create a Beautiful Power BI Report, and Patrick has discussed Why is there a limited relationship when using the same data source? (spoiler alert - double check your case sensitivity!)
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Patrick Leblanc (@GuyInACube) talks about Why is there a limited relationship when using the same data source?
- Chandeep Chhabra (@chandeep2786) explains Don't make these CALCULATE Function Mistakes
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) describes how to Toggle Measures in Power BI
- Sam McKay (@_EnterpriseDNA) covers Dealing With Seasonal Budget Allocations in Power BI [2023 Update] and explains How To Calculate Percent Profit Margins In Power BI [2023 Update]
- Franky Leeuwerck cover Power BI import duurt te lang? Kijk eens naar DirectQuery, Aggregaties en Dual opslagmode [Dutch]
- Rafael Mendonça (@rafaelmpsantos) covers Power BI - Não edite seus Modelos do Power BI na Nuvem [Portuguese]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to Format Visual in the New Power BI Desktop
- Fowmy Abdulmuttalib (@ExcelFort) writes about Super Trick: Extract Images and Page Backgrounds from Power BI Files
- Adam Saxton and Mara Pereira (@GuyInACube) discuss Want a Beautiful Power BI Report? Start Here
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Top N Filter in Microsoft Power BI Desktop on Chart Visualization (Top 5 / Bottom 5)
- Reid Havens (@HavensBI) explains how to Create Any Visual in Power BI with the HTML VizCreator (with Pascal Kiefer)
- On the Learning Science YouTube channel, Learning Science describes Comparison Chart in Power BI - A Custom Visual
- Ilya Rzhevskiy (@ilya_sb1) writes about Power BI: add KPI arrow triangles to your Variance Metrics
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Lauren Faber (@MSPowerBI) shares Pre-Announcing Better Power BI Report Integration with OneDrive and SharePoint (Preview)
- Chris Webb (@cwebb_bi) writes about Power BI Automatic Refresh Retries
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe Power BI Incremental Refresh: What Is It and How to Use It
- Also on the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about What is Power BI Gateway? All You Need to Know
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 225
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.