Weekly Roundup for August 2, 2021

After you've mastered Power BI Desktop, the most important tool for taking your data analytics career to the next level is Tabular Editor. Daniel Otykier, the creator of Tabular Editor, has just released the third full version, and it is chock full of advanced features.

If you work on Power BI datasets on a regular basis--particularly large, complex datasets with several tables, dozens or hundreds of metrics, and a lot of data--then this is the professional, enterprise-grade tool that you will need.

Daniel Otykier joins the Nashville Modern Excel & Power BI User Group to give us a walk-through of the best Power BI tool that isn't Power BI. Be sure not to miss out on this great presentation!


Gartner has named Microsoft as a Leader in Robotic Process Automation.


Marc Lelijveld has a nice, simple explanation of what makes a Power BI solution enterprise-grade. Definitely worth a quick read.


If you need a primer on making paginated reports, Blue Granite has a nice introduction.


Patrick LeBlanc has a great introduction to using R in Power BI. There are a few limitations, including the need to use a personal gateway, so check the documentation.


Reid Havens has a nice, concise introduction to using composite models in Power BI — that is, a composite of a direct query connection to a Power BI dataset and some other data source. This allows for endless mashups of data and high customizability.


I honestly didn’t know that you could use normal text boxes as de facto smart narrative visuals. Patrick LeBlanc shows you how you can use text boxes to really customize the text that you bring to your Power BI reports.