In this video, Patrick shows a way you can use parameters and templates, with Power BI Desktop, to provide prompts for your connection's server and database properties. This is great for when you are creating a report, and need to share it with a customer that may have a different name for the server and [...]
In this video, Patrick shows how you can successfully connect to your SQL Server Always On Availability Group (AG) Secondary Read Replica using Power BI Desktop and the On-Premises Data Gateway. Adam jumps in to show you what the connection string looks like when you use this approach. Configure Read-Only Routing for an Availability Group [...]
Hurricane Harvey Donations: American Red Cross Salvation Army Humane Society Hurricane Harvey Relief Fund Roundup Items: Context Transition in DAX/Power BI: A Visual Guide (@csgpro) Multilanguage Multilingual reports in Power BI (@CurbalEN) Introducing per-user usage metrics: know your audience and amplify your impact Create interactive timeline visualizations for your data with the new timeline storyteller community [...]
Changing the culture of a Power BI Desktop file (@marcorus) Solar Eclipse 2017 In Power BI (@datachant) Power BI Developer community August update Power BI On-premises data gateway August update Show us your creative What If and win swag! BONUS ITEMS: PREPARING FOR MICROSOFT CERTIFICATION EXAM 70-778: ANALYZING AND VISUALIZING DATA WITH MICROSOFT POWER [...]
In this video, Patrick looks at the ragged hierarchy problem within Excel and Power BI when you are pulling data from Analysis Services. He looks at how you can correct the issue easily within Excel and some alternatives for Power BI.
In this video, Patrick shows how you can fix quick measures that break when you use dates with time calculations. Patrick referenced a blog from Kasper de Jong. You can find that here: Use the Power BI quick calcs with your own date table
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 [...]