In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
Take this short survey to influence our plans for AI in Power BI This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-ai-survey/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-ai-survey/. The author isFollow @gilra The Microsoft Business Application Summit was a blast. If you missed it, you can now watch all the Power BI session recordings here, or get a great snapshot for the major new features on the FourMoo blog. This post first appeared at https://datachant.com/2019/06/13/powerquery-com-and-my-recorded-sessions-at-mbas-2019/. The author is Gil RavivRead More
This post first appeared at https://datachant.com/2019/06/13/powerquery-com-and-my-recorded-sessions-at-mbas-2019/. The author is Gil RavivThe conference might be over, but there’s so much more in store! Get ready to transform your business with the latest in Microsoft Business Applications. Explore 200+ sessions, workshops, and keynotes from Microsoft Business Applications Summit, available now in the Power BI Community. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-demand-now-full-session-lineup-from-microsoft-business-applications-summit/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-demand-now-full-session-lineup-from-microsoft-business-applications-summit/. The author isTake our quarterly survey to help us continue to improve Power BI. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-quarterly-survey-june-2019/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-quarterly-survey-june-2019/. The author is“Who, or what, is Paginated Report Bear?” I hear you ask. Well, he’s the breakout social media star of 2019, a furry YouTube sensation whose incisive interviews of members of the Power BI development team have become renowned for their deep technical content and insights into the Power BI roadmap. If you’re not watching his […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/tY8b6-T5z3U/. The author is Chris WebbYour Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one. Then, you filter out the obsolete versions of customers,… This post first appeared at https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/. The author is Fred KaffenbergerRead More
This post first appeared at https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/. The author is Fred KaffenbergerLevel: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window. Think of it a bit like Rolling 12 Months Sales, or average weekly sales over a rolling 4 week period, but […]
This post first appeared at https://exceleratorbi.com.au/solving-a-complex-time-problem-in-power-bi/. The author is Matt AllingtonToday, we’re announcing general availability (GA) for cognitive services, Azure ML and the AI workload in Power BI Premium. The AI workload will now be enabled by default for all P-nodes, as well as nodes A3/EM3 and above, allowing the users of those capacities to use cognitive services in dataflows right away. A new workload […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-ai-premium-workload-cognitive-services-and-azure-ml-general-availability/. The author isAs we kick off the Microsoft Business Application Summit with our amazing community at Atlanta, I wanted to share some exciting Power BI news as part of the event, including the June release of Power BI Desktop and the general availability of Paginated Reports in the service. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-new-ai-and-enterprise-features-for-power-bi/. The author is Read […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-new-ai-and-enterprise-features-for-power-bi/. The author isHopefully, you are either enjoying the start of the Microsoft Business Applications Summit or watching all the exciting news and announcements on social media! To go along with all those other announcements, we, of course, also have a big update for our June update for Power BI Desktop. There are a lot of new features […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/. The author isBased on the technology used in SQL Server Reporting Services, Paginated Reports brings a new set of enterprise reporting capabilities to the Power BI service. It enables developers and BI professionals to create and distribute highly formatted, pixel-perfect reports right alongside their interactive Power BI content, becoming the first cloud BI solution that combines the […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/. The author isTemplate app general availability announcement and latest features This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-template-apps-general-availability/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-template-apps-general-availability/. The author isWe’re happy to announce that the Power BI Mobile iOS app is now integrated with Siri shortcuts. Now, you’ll be able to just say “Hey Siri, open my report” and you’ll get the content you’re looking for. Together with Siri shortcuts, we’re also introducing device level search (Spotlight) which allows you to easily search for, […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-siri-integration-with-power-bi-mobile-ios-app-preview/. The author isRecently I found I needed to remove all the HTML tags from some text in Power Query. I searched and found a great – if complex – function from Marcel Beug here, but I realised that since that post was written the Html.Table M function has been added to the language and that it makes […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/9OjjXKS575c/. The author is Chris WebbAre you attending Microsoft Business Applications Summit next week? I hope you can join my session on Power Query and get a chance to win a print version of my book. We will run an automated raffle (using Power Query and Microsoft Flow) and give away 8 books during the session. And if you want […]
This post first appeared at https://datachant.com/2019/06/07/book-update/. The author is Gil RavivJune gateway release This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-june-2019-update-is-now-available/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-june-2019-update-is-now-available/. The author isWe’re almost halfway through the year and what a great start it’s been to 2019! The Power BI team continued to deliver some of the most anticipated features in the month of May. We were also heads down planning for the Microsoft Business Applications Summit, where we look forward to connecting with many of you […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-may-2019-feature-summary/. The author isIt is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this). One such example is shown below, where the data in the table on the left hand side needs to be transformed into the table […]
This post first appeared at https://exceleratorbi.com.au/pivoting-text-data-using-power-query/. The author is Matt AllingtonThis blog post covers the latest updates for Power BI embedded analytics and Custom Visuals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-april-may-update/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-april-may-update/. The author isIn Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a title, info is exported with a generic title of “Data.”… This post first appeared at https://powerpivotpro.com/2019/06/export-power-bi-data-with-date-range-in-title/. The author is Fred KaffenbergerRead More
This post first appeared at https://powerpivotpro.com/2019/06/export-power-bi-data-with-date-range-in-title/. The author is Fred Kaffenberger