In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
In addition to the 20 tracks lead by the community, technical experts and Industry luminaries presenting at the upcoming Power Platform Summit in Amsterdam, the Microsoft Team will be there in full force presenting the Microsoft Power Series track– over 15 hours of deep dive and hands on content. These sessions are included in both the Power […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/connect-with-the-microsoft-product-team-in-amsterdam-at-power-summit/. The author isToday, we’re excited to announce that Power BI is making it easier for Azure AD B2B Guest users to collaborate with colleagues across organizational boundaries. Rolling out to production this week is a new capability that allows external Guest users to edit and manage content in workspaces, get the full home experience, and to do […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/azure-ad-b2b-guest-users-can-now-edit-and-manage-content-in-power-bi-to-collaborate-better-across-organizations/. The author isSQLBits is one of the best Microsoft data platform conferences around, and last week’s event in Manchester was particularly good. As usual, videos of almost all of the sessions are available for everyone to view for free online (no registration required) here: https://sqlbits.com/content/Event18 This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/X-NmO8LW5Ps/. The author is Chris WebbRead More
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/X-NmO8LW5Ps/. The author is Chris WebbWe are happy to announce the General Availability (GA) of Multi Geo for Power BI Premium! With Multi Geo going GA, you can extend your Power BI tenant to store your users’ data in the geographies covered in the Microsoft Trust Center, except for Power BI Germany, Power BI China operated by 21Vianet or Power […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-multi-geo-general-availability/. The author isThe Power Platform World Tour is well underway with a huge success at Tampa, recently wrapped up its second stop in Silicon Valley, California and Washington DC and Chicago right around the corner. With 24+ breakout sessions covering topics across the entire Power Platform, expert speakers, and great conversations fueled by gallons of coffee, it’s […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-power-platform-world-tour-2-stops-down-endless-possibilities-to-go/. The author isOptimization has become one of my favorite topics. OK, I’ll admit it: it might be an obsession and a source of joy. My inability to optimize (queries, data models, and DAX) used to be a source of headaches and the… This post first appeared at https://powerpivotpro.com/2019/03/dax-optimizations-write-it-like-the-dax-calls-it/. The author is Matthew MowreyRead More
This post first appeared at https://powerpivotpro.com/2019/03/dax-optimizations-write-it-like-the-dax-calls-it/. The author is Matthew MowreyWe have a 5-minute survey regarding the default theme color when you publish a Power BI app to your consumers. We’d love for you to tell us what your preference is for the default color preference and why that is important to you. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-app-theme-color-survey/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-app-theme-color-survey/. The author isI woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits. Microsoft is adding “Calculation Groups” to the DAX language. There are a number of blogs already that talk about the announcement, including Chris Webb and The Italians, but I wanted to give my […]
This post first appeared at https://exceleratorbi.com.au/calculation-groups-are-coming-to-dax/. The author is Matt AllingtonGet ready to flex your business applications skills – and pick up some new ones – at Microsoft Business Applications Summit. Coming to Atlanta, Georgia June 10 – 11, 2019, this is the place to dive deep with the tools you use every day, get a sneak peek at what’s new and next, and connect […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlock-next-at-microsoft-business-applications-summit-2019/. The author isMicrosoft released the new Template Apps recently, and I am extremely happy to share my first App with you. It is publicly available on Microsoft AppSource. You can now explore Power BI Custom visuals via my Power BI Template App, and share it with your end-users in your organization for free from here. This post […]
This post first appeared at https://datachant.com/2019/03/04/template-app-custom-visuals-exploration-tool/. The author is Gil RavivIn modern BI projects, understanding the flow of data from the data source to its destination, and understanding the data transformation done along the way, is a key challenge for many customers. This challenge becomes even bigger if you have built advanced analytical projects spanning multiple data sources, artifacts, and dependencies. Questions like “What happens […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-data-lineage-experience-for-dataflows/. The author isWith the release of CTP 2.3 of SQL Server 2019 today there was big news for Analysis Services Tabular developers: Calculation Groups. You can read all about them in detail in this blog post: What’s new for SQL Server 2019 Analysis Services CTP 2.3 This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/4-ReOjipweg/. The author is Chris WebbRead More
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/4-ReOjipweg/. The author is Chris WebbWe are happy to announce that we have just released the February update for the On-premises data gateway (version 3000.1.257) This month’s Gateway update includes an updated version of the Mashup Engine, which matches the […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-february-2019-update-is-now-available/. The author isI was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including: Extract the Year into 1 column Extract the Month […]
This post first appeared at https://exceleratorbi.com.au/query-by-example-to-extract-yyyy-mm-from-a-date-column/. The author is Matt AllingtonA new whitepaper authored by Peter Myers presents a comprehensive body of knowledge covering all aspects of deploying, scaling, troubleshooting and managing a Power BI Premium deployment in an enterprise. The whitepaper provides both background information explaiing how various Power BI concepts play together in an enterprise deployment as well as practical examples of challenges encountered in […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-premium-deployment-and-management-whitepaper-added/. The author isA couple of people have asked me recently about how to ‘bone up’ on the new data lake service in Azure. The way I see it, there are two aspects: A, the technology itself and B, data lake principles and architectural best practices. Below are some links to resources that you should find helpful. Learning […]
This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/Uca8yuBnoKU/resources-for-learning-about-azure-data-lake-storage-gen2. The author is Melissa CoatesTo ensure employee productivity and satisfaction with Power BI, enterprise organizations develop comprehensive product training, bolster their help desks, and invest in helping their user communities with internal forums to share ideas and best practices. But it can be a challenge to educate users about the availability of these organizational resources. The exciting news is […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/tailoring-help-and-support-for-power-bi-users/. The author isBusiness Problem: In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page. The client had been maintaining a table of KeyPhrases that correspond with Categories. If the… This post first appeared at https://powerpivotpro.com/2019/02/powerquerymagic-conditional-joins-using-table-selectrows/. The author is Justin MannhardtRead More
This post first appeared at https://powerpivotpro.com/2019/02/powerquerymagic-conditional-joins-using-table-selectrows/. The author is Justin MannhardtFollow @gilra In today’s blog post, I share the generic solutions for the Fill Down challenge that I posted here. This post first appeared at https://datachant.com/2019/02/25/the-fill-down-hierarchies-challenge-3/. The author is Gil RavivRead More
This post first appeared at https://datachant.com/2019/02/25/the-fill-down-hierarchies-challenge-3/. The author is Gil RavivWith our February update of Power BI, you can now share, publish and view Python visuals in your reports and dashboards. This update extends the support for Python in the Power BI Desktop to the Power BI service. This ability completes the support for Python in Power BI, enabling you to use Python scripts to […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/. The author is