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!
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 [...]
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.
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 [...]
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 [...]
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...", [...]
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 [...]
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.
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 [...]
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 [...]