Report level measures with Power BI live connections

In this video, Patrick looks at how you can create report level measures, within Power BI Desktop, against SQL Server Analysis Services Tabular live connections, or against a Power BI service dataset live connection. He also explains what is meant by report level measures. Bust out your DAX toolbelt and have a look!

Lots of Power BI updates and some DAX

Use Multiple Connections Between Tables (@PowerBITips) The ALL() Function in DAX (@ExceleratorBI) Responsive visualizations coming to Power BI Power BI Desktop July Feature Summary Power BI Service and Mobile June Feature Summary BONUS ITEMS: Data Privacy Settings In Power BI/Power Query, Part 4: Disabling Data Privacy Checks (@Technitrain) Integrate Power BI into Your Application: Part [...]

Fixing Time Calculations in Power BI

In this video, Patrick shows why you may hit some issues with time calculations and how to fix time. He typically sees this when using a Data Warehouse.

Announcements, whitepapers, and APIs

Power BI Premium generally available Data Insights Summit Opening Keynote White Paper On “Planning A Power BI Enterprise Deployment” (@technitrain & @SQLChick) Defining variables in DAX queries (@marcorus) Power BI Desktop June Feature Summary Announcing Data Refresh APIs in the Power BI Service BONUS ITEMS: Microsoft Data Insights Summit 2017 Day 1 Recap Microsoft Data [...]

Create Power BI reports in Power BI Report Server

In this video, Adam walks through the steps to create your Power BI Report in order to publish it to Power BI Report Server. This involves downloading and installing Power BI Desktop optimized for Power BI Report Server and connecting to Analysis Services live connections. I also show how you can work around the dreaded [...]

Tooltips, tooltips, tooltips in Power BI

In this video, Patrick shows how you can display multiple values within a tooltip for a visual. He walks through the DAX measure and also shows some pitfalls to look out for when it comes to filter context. DAX Sample Statement: Color Tooltip = var itemcount = DISTINCTCOUNT(StockItem[Color]) return IF(itemcount > 3, CONCATENATEX(TOPN(3,VALUES(StockItem[Color])),StockItem[Color],",")&" and more...", [...]

Power BI Report Server, data privacy and more

Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implications (@technitrain) SSAS TABULAR VS MULTIDIMENSIONAL FEATURE MATRIX (@BrettPowell76) Reusing Datasets Imported to the Power BI Service (@SQLChick) Power BI Report Server preview now available What’s new in SQL Server 2017 CTP 2.1 for Analysis Services BONUS ITEMS: How to compute index numbers at top [...]

Dynamic Power BI reports using Parameters

In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh.

Install and configure Power BI Report Server (May 2017 Preview)

In this video, I look at how to install and configure the May 2017 Preview of Power BI Report Server. Power BI Report Server has a new standalone install experience and this product allows for Power BI reports to be rendered in the web portal along with paginated reports. This will get you started with [...]

Power BI Premium, Apps and Report Server

So many announcements for Power BI this week! Also, it is Star Wars day!!! May the 4th be with you! Power BI Desktop May Feature Summary Microsoft accelerates modern BI adoption with Power BI Premium Power BI Premium Calculator Power BI initial SKU and pricing information Power BI Premium webinar (May 11th) Distribute to large [...]