Power BI & SQL Server Always On Availability Groups

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 [...]

Languages and timelines in Power BI and previews

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 [...]

Eclipse, culture, Power BI updates and a contest!

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 [...]

Fixing Power BI Quick Measures – Time calculations

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

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 [...]