Tuesday – Power BI Technology and More
Every Tuesday, I look at a tech topic. This could be a new feature, how something works or how to troubleshoot something within Power BI technology, Reporting Services and Analysis Services.
This may also include the occasional topic relating to the Microsoft Data Platform as a whole, such as SQL Server or an Azure technology. Because of Power BI, there will also be content related to Office 365 and Azure Active Directory.
Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles
Adam walks through how to setup a live connection to Analysis Services, or Azure Analysis Services, in Power BI Desktop. This also involves getting things working with the On-Premises Data Gateway.
Patrick shows the magic of getting cross-report drillthrough working in Power BI. He teaches you the clicks to getting this going successfully. Demo files: https://guyinacu.be/demofiles
Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your Power BI Reports shine. Connect with [...]
If you are using slicers in your Power BI report, moving them off to the filter pane could improve performance. Patrick shows you what this could look like based on a real customer story.
Import vs. DirectQuery vs. Live connection. Which do you choose and why in Power BI? Adam looks at the three options when creating reports in Power BI Desktop. DirectQuery in SQL Server 2016 Analysis Services [...]
5 tips for Power BI Paginated reportsJune 19th, 2019
Power BI Twitter report for Business Application SummitJune 7th, 2019