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 Whitepaper Data sources supported by DirectQuery in Power BI
Patricks walks through what you can do with the Power BI Desktop Model View. From bulk operations to organizing your relationships in the Power BI data model, there are a lot of great things.
Getting "Failed to load data model" for an Azure Databricks DirectQuery connection in Power BI? Adam hit it too and walks through how to fix it in Power BI Desktop using Power Query.
Do you want a customized KPI Card in Power BI? Patrick looks at how you could get a custom KPI Card in a Power BI report without using custom visuals. KPI Card demo files - https://guyinacu.be/kpicardfiles
Do you see too many map locations in your Power BI Mobile report? Patrick shows you how to limit the points using Microsoft Flow.
Have you struggled when dragging month name to a chart axis and it is sorted alphabetically in Power BI Desktop? Adam shows you how you can change the sort order to be chronologically instead of alphabetically. This technique can also be used for other categorical columns in Power BI.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup131 2 Minute Tuesday: https://guyinacu.be/helpurls Patrick's tech video: https://guyinacu.be/keyinfluencer Adam's tech video: https://guyinacu.be/powerbisupport Sources 5 ways to get Power BI Support #pbifamily Curbal's Video Power BI Documentation Start learning Data Modeling for free (@marcorus) Three Ways to Use Power BI Dataflows (@SQLChick) Melissa [...]
Patrick and Justyna look at how you gain insights using the Key Influencer visual in Power BI Desktop. This is the first Power BI AI visual, with more to come. Follow Justyna on Twitter - https://twitter.com/JustynaLucznik
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup130 2 Minute Tuesday: https://guyinacu.be/screencapture Patrick's tech video: https://guyinacu.be/5thingsdesktop Adam's tech video: https://guyinacu.be/reportconsumers Sources Power BI Now Has Keyboard Accessible Visual Interactions (@mmarie) How to get fast, good and free Power BI support (@CurbalEN) How to do multivariate reporting with Power BI https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9750957-vertical-and-horizontal-multiples-small-multiples [...]
Patrick shows you 5 things you didn't know about Power BI Desktop. Some potentially hidden things that may not be obvious and will help you out when creating Power BI reports within Power BI Desktop.