In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
What is the maximum length of a text value in Power BI? It turns out that this is a more complex question than you might think! The maximum length of a text value that the Power Query engine can load into a single cell in a table in a dataset is 32766 characters – any […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/ydaCkoh5EhE/. The author is Chris WebbWe have an exciting release this month. On top of incremental improvements for several of our recent released features, such as the key influencers visual and our new filter pane, we also have a new performance analyzer pane. This new pane lets you get a behind the scenes view of what’s happening when your report […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2019-feature-summary/. The author isMicrosoft Business Applications Summit June 10 – 11 in Atlanta, Georgia is almost here and you have one more reason to attend year…A chance to meet the community super stars. We know, one of the primary reasons people go to conferences is to meet the presenters. And at the Microsoft Business Applications Summit (MBAS), we have an entire “Ask […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/meet-community-stars-at-microsoft-business-applications-summit/. The author isWe’re happy to announce one of our most commonly requested features for custom connector support in Power BI – Trusted Third Party Connectors. As it stands today, the only way that you can use a connector with the ‘Recommended’ security setting is for it to be signed and distributed by Microsoft. Unfortunately, this stops a […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/trusted-third-party-connectors-for-power-bi/. The author isI often get asked about measure tables during my Power BI online training classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes from. What is a Measure Table? A measure table is a dedicated table used to store some or all of the […]
This post first appeared at https://exceleratorbi.com.au/measure-tables-in-power-bi/. The author is Matt AllingtonNow that tax season is over, are you ready to see how your contributions are helping the government run? As it did in 2017 and 2018, USAFacts published a 10-K Report using Microsoft Power BI to show a comprehensive view of US federal, state and local governments’ revenues and expenditures. The not-for-profit, non-partisan institute—funded by former Microsoft […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/through-power-bi-usafacts-explores-government-financial-data-in-latest-report/. The author isWe can’t wait for Microsoft Business Applications Summit this year – and it’s almost here! Coming to Atlanta, Georgia June 10 – 11, this is your chance to get hands-on with your favorite tools, go one-on-one with experts and engineers, and collaborate with our vibrant community of data drivers. Why Attend? Top 10 reasons to join us in June. Learn more about Microsoft’s […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-business-applications-summit-top-10-reasons-to-attend/. The author isJune 11-12 are getting near, and it is this time of the year to start getting excited. Microsoft Business Applications Summit is getting close. Do you plan to attend it? I will be glad to meet you in person in one of my sessions that will focus on my Power Query book and the development […]
This post first appeared at https://datachant.com/2019/05/13/my-sessions-at-mbas/. The author is Gil RavivApril was packed full of new capabilities for Power BI. Thank you for the ongoing support and feedback – we couldn’t have done it without you. Here’s a quick rundown of everything we announced last month: Power BI dataflows GA Q&A update for dashboards New workspaces experience GA Paginated Report Builder New Power BI regions […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-april-2019-feature-summary/. The author isOne of the many big announcements at Build this week, and one that caused a lot of discussion on Twitter, was about Wrangling Data Flows in Azure Data Factory. You can read the blog post here: https://azure.microsoft.com/en-us/blog/analytics-in-azure-remains-unmatched-with-new-innovations/ This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/zgPeazvPG_8/. The author is Chris WebbRead More
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/zgPeazvPG_8/. The author is Chris WebbThe Power Platform User Groups (Power BI, PowerApps, and Flow) are excited to announce that they have added another stop to the Power Platform World Tour – They are headed to beautiful Vienna, Austria! We have several other stops planned in 2019 such as: London Madrid Copenhagen Sao Paulo Mexico City Vienna Where would you […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/where-in-the-world-is-power-bi-world-tour-dates-locations/. The author isI am happy to announce the release of a new version of the Power BI free template app Custom Visuals Exploration Tool. Download it from AppSource here. Follow @gilra This post first appeared at https://datachant.com/2019/05/08/new-version-custom-visuals-exploration-tool/. The author is Gil RavivRead More
This post first appeared at https://datachant.com/2019/05/08/new-version-custom-visuals-exploration-tool/. The author is Gil RavivWe are happy to announce that we have just released the May update for the On-premises data gateway (version 3000.5.185). Here are some of the things that we would like to highlight with this month’s release: Gateway Performance Monitoring (Public Preview) Amazon Redshift Refresh via the on-premises data gateway May version of the mashup engine […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-2019-update-is-now-available/. The author isDMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available in Azure Analysis Service, Power BI and Power Pivot and are useful for a variety of reasons, for example for generating documentation. Several as-yet undocumented DMVs have appeared in […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/R-2ttyAvOpQ/. The author is Chris WebbWelcome back! Today we are going back to RANKX-apalooza! We are going to add two approaches that will allow you to apply RANKX across multiple columns. I went back and recreated the examples from the original post using the AdventureWorks… This post first appeared at https://powerpivotpro.com/2019/05/rankx-apalooza-part-2-within-and-across-groups-with-filters-etcand-using-multiple-columns/. The author is Jason BaldessariRead More
This post first appeared at https://powerpivotpro.com/2019/05/rankx-apalooza-part-2-within-and-across-groups-with-filters-etcand-using-multiple-columns/. The author is Jason BaldessariBack in September of last year, we announced dashboard commenting in Power BI. Since then, we’ve seen thousands of you leverage this feature to collaborate with colleagues and start discussions within your organization. Today, I’m excited to announce that we are bringing the same commenting capability to Power BI reports! With report commenting, you can […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-report-commenting-for-power-bi-service-and-mobile/. The author isI had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a similar problem Fill Table with Last Survey Result using DAX here. The solution I am providing in this blog post is using […]
This post first appeared at https://exceleratorbi.com.au/expanding-rows-using-power-query/. The author is Matt AllingtonFor the fifth week in a row, we’re pleased to announce two new features on “New Feature Friday” for Paginated Reports in Power BI. We’ve added support for two new data sources, Oracle and Teradata, and also added the ability to schedule your e-mail subscriptions on an hourly basis. Oracle and Teradata Now Supported We […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/oracle-and-teradata-data-source-support-and-hourly-e-mail-subscriptions-for-paginated-reports-now-available/. The author isWay back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Reid Havens a couple of months ago. I blogged about various other ways of doing this, including banded columns using DAX […]
This post first appeared at https://exceleratorbi.com.au/grouping-in-power-bi-desktop-without-using-dax/. The author is Matt AllingtonI’m one of those people who can’t resist peeking behind the scenes, and so when the Key Influencers visual appeared in Power BI I couldn’t help wondering how it worked its machine learning magic. Using DAX Studio to look at the DAX queries generated by the visual proved to be very revealing: it turns out […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/WJWNS7zycLw/. The author is Chris Webb