Power BI Weekly Issue 92: 12th January 2021
Only the one announcement this week, but it's quite a biggie for Premium/Embedded users out there: Announcing the general availability of read/write XMLA endpoints in Power BI Premium. The XMLA endpoint has opened up a huge number of possibilities for automated operations on your data model, including the automated testing of Power BI data models, for example. Elsewhere, Reza Rad has shown how to use Power Automate to Refresh a dataset after a successful refresh of a dataflow, Sam Fischer has described how to Calculate business hours between activities using DAX, and Patrick Leblanc has explained how to Migrate your Paginated reports to Power BI using the RDL Migration tool.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Mimoune Djouallah (@mim_djo) describes how to Pushdown Filters to Parquet From Power BI Using Synapse Serverless and writes about Power BI incremental refresh Parquet files
- On the RADACAD blog, Reza Rad (@Rad_Reza) blogs about Power BI Dataflow vs Data Warehouse: Which one to choose?
- Chris Webb (@cwebb_bi) talks about Handling Multiple URL Query Parameters With The Same Name Using Web.Contents In Power Query/Power BI
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) covers [PowerQuery] My Best practices in Transform Data
- On the Power BI Community blog, Paul Zheng describes how to Dynamically Display the Most Recent N Days using PQ
- Also on the Power BI community blog, Christi Lemahieu blogs about Connecting Power BI Desktop to Zabbix
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes about 4 méthodes pour la conversion de devises avec Power Query [French]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Filtering the top products alongside the other products in Power BI
- Mimoune Djouallah (@mim_djo) discusses Push Dataset in Power BI Composite Model, Near real Time made easy!!! and describes how to Load Data to Power BI Push Dataset using Easymorph
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Static vs Dynamic ranking in Power BI
- Mudassir Syed Rashid Ali provides an Introduction to Calculation Groups, writes about the Small Multiple Visual - A Holiday Gift From Microsoft and explains How Small Multiple Visual Interacts With Calculation Groups In Power BI
- Phil Seamark (@PhilSeamark) presents Power BI Dev Camp: how to program datasets using the Tabular Object Model (TOM)
- Krešimir Ledinski (@Exceed_ltd) discusses Sorting in Matrix created with calculation groups Power BI
- Parker Stevens (@PowerBIElite) talks about Refreshable Currency Conversion with Dynamic Formatting in Power BI
- Paul Turley (@paul_turley) provides A First Look at Gen 2 Composite Models with Live Power BI Datasets
- Sam Fischer describes Calculating business hours between activities using DAX
- Daniil Maslyuk (@DMaslyuk) writes about Built-in column sort order in Power BI
- Marcus Wegener (@PowerBIler) writes Power BI Dataset mit eignen Daten erweitern [German]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Adam Saxton (@GuyInACube) provides an Alternative to sharing a Power BI Personal Bookmark
- Daniel Marsh-Patrick (@the_d_mp) writes that the HTML Content Website Now Available
- On the Power BI community blog, Ted Pattison (@TedPattison) highlights the Power BI Dev Camp: January 28th -Learn to Develop Custom Visuals
- Also on the Power BI community blog, Icey Zhang describes how to Use R to highlight specific data point in Power BI
- On the MSSQLTips site, Scott Murray talks about Power BI Theme Generator New Methods and Customizations
- On the Towards Data Science blog, Aveek Das (@avikoleum) writes about Conditional formatting in Power BI
- Matthew Peterson (@mattpetersonbi) shares some Power BI Maps Tips and Tricks
- On LaDataWeb, Ignacio Barrau (@ignacho_07) shares some Custom visuals de interés [Spanish]
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, Ogbemi Ekwejunor-Etchie announces the general availability of read/write XMLA endpoints in Power BI Premium
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Power BI User Access Levels: Build and Edit are different and explains how to Streamline Power BI Refresh: Refresh dataset after a successful refresh of dataflow
- Philipp Lenz (@lenz_philipp) describes Why should you aware of the connection details in a Power BI file?
- Adam Saxton (@GuyInACube) provides A look back and what is to come for Power BI and Guy in a Cube (Roundup | Jan 4, 2021)
- Gilbert Quevauvilliers (@GilbertQue) writes that You can now view the Power BI REST API calls via the Audit log
- Dhruvin Shah (@DhruvinShah16) has created a Power BI Embedded Step by Step Series
- Marc Lelijveld (@MarcLelijveld) describes how to Extract refresh metrics for your entire Power BI workspace
- On the Power BI Community blog, Srishti Sharma writes about the issue: Unable to schedule refresh in PBI Service for a Web Data Source
- On the Power BI Community blog, Lin Li describes Batch migration from one pbix file to another pbix
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Patrick Leblanc (@GuyInACube) explains how to Migrate your Paginated reports to Power BI
- The Power BI team (@MSPowerBI) provides an Introduction to Power BI Deployment pipelines
- Mikael Hermansson describes How to visualize your nested IoT data in 3d using Spark and Power BI
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 175 - Interview with Christian Wade
- Adam Saxton and Patrick Leblanc (@GuyInACube) talks about REPLAY Power BI tips from the Pros – LIVE (Jan 9, 2021) (Member Chat 2nd Half)
- On the Power BI Tips and Tricks blog, Melissa Coates (@SQLChick) talks about Power BI End-to-End Architecture
- Gil Raviv (@gilra) writes about COVID-19 Global Vaccination
- Spencer Baucke (@JSBaucke) blogs about Interview Questions for Tableau & Power BI
- Wolfgang Strasser (@wstrasser) writes about Azure Synapse Analytics end-to-end: From your database and sensors to a Power BI dashboard
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.