Episode 167 – What election? Let’s talk about Power BI News
This is episode 167 recorded on November 6, 2020 where John & Jason talk about the election… and then Power BI News. We promise we really do. Topics like Updates to Power BI Publish to web for better public reporting, Priority Access sign-up for Power BI Premium per user public preview now available, and Paginated Report November 2020 Feature Summary.
Updates to Power BI Publish to web for better public reporting
The enhanced compute engine is now enabled by default
Priority Access sign-up for Power BI Premium per user public preview now available
Announcing Power BI Connector to Azure Databricks Public Preview
Certified and Promoted reports and apps
Paginated Report November 2020 Feature Summary
DAX calculations at visual level of reports
Provide a simple way to write formulas that work with the data displayed in a visual. For example, the running total of a measure in a table or in a chart according to the sort order of the visual should be something like this:
Running Total = ReportData[Sales] + PREVIOUS ( ReportData[Running Total] )
Where ReportData is the content of the current visual, Sales and Running Total are the names of the columns in the current visual. The user is not expected to know the model content, the calculation can be executed on top of any data currently being displayed.
More details about a proposal for visual calculations in DAX here:
Allow Table and Matrix Data Exports to Match PowerBI Visual – 5012 votes
I have volumes of information to share with my teams that is best presented in tables and matrices. It would be a huge improvement if they were able to export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.
This would be especially helpful for ongoing forecasting activities.