In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
There were a lot of exciting announcements at the Microsoft Business Applications Summit this week but if you only watched the keynotes or read the recap on the Power BI blog you will have missed all the Power Query-related news in the “Data Prep in Power BI, Power Platform and Excel using Power Query” session: […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/uTEJXPv80ro/. The author is Chris WebbFollowing my last tutorial, I have updated the COVID-19 Power BI app on AppSource (download it here) and added incremental confirmed cases and deaths columns using Power Query. While the refresh is now longer, you can see in the screenshot below that the calculation time is significantly improved (around 2-10 times faster). For one of […]
This post first appeared at https://datachant.com/2021/05/07/optimized-covid-19-report-on-appsource/. The author is Gil RavivExcel Organisation data types were released last year (see here for details), but did you know that you can now use them to bring images as well as text and numbers into Excel? Here’s a super-simple example that shows you how to do this. Here’s a table called ‘Fruit With Image’ in a dataset that […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/WdcL0Z7LMrE/. The author is Chris WebbWe’re excited to announce a new sharing experience that allows sharing reports via links. Previously in the old experience, we supported sharing reports by granting direct access. For the new experience, reports can be shared via links in addition to direct access sharing. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-new-sharing-experience/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-new-sharing-experience/. The author ise are excited to announce the public preview of Backup and Restore for datasets in Power BI Premium and Premium per User (PPU). You can now use SQL Server Management Studio (SSMS), Analysis Services cmdlets for PowerShell, and other tools to perform backup and restore operations in Power BI via XMLA endpoints in much the […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-support-for-backup-and-restore-of-power-bi-datasets/. The author isThe Query Plan visual will allow you to understand what’s happening under the hood of your query with more details than the Step Folding indicator. This post first appeared at https://powerbi.microsoft.com/en-us/blog/query-plan-visual-for-power-query-online/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/query-plan-visual-for-power-query-online/. The author isIn this tutorial, we will learn how to convert cumulative numbers to incremental values using Power Query. In one of our earlier COVID-19 tutorials here, we learned how to convert cumulative values to incremental ones using DAX. We worked with Johns Hopkins University’s COVID-19 dataset that includes only the cumulative confirmed cases and applied the […]
This post first appeared at https://datachant.com/2021/05/05/from-cumulative-numbers-to-increments/. The author is Gil RavivThere is a big chance you haven’t been able to catch all the news at MBAS or that some items just escaped your attention as they were drowned out by the next big thing. Don’t worry, we’ve got your back. In this post we do our best to recap what happened en provide links to […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-business-application-summit-recap/. The author isOrganizations exist to achieve business objectives and in today’s data driven world, we know that progress is measured through data. However, this is often challenging as goal tracking systems are disconnected from your business data and often require manual updates. Not only that, but goals need to be optimized for teamwork, tightly integrated into core […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-goals-in-power-bi/. The author isMicrosoft Business Applications Summit is one of my favorite events of the year. While we connect with our customers, our community, and our partners every day, at the Microsoft Business Applications Summit, we share some of our most important announcements on our strategy and roadmap. We prepare and deliver some really exciting demos and our […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/driving-a-data-culture-with-power-bi-empowering-individuals-every-team-and-every-organization/. The author isIf you have a slow DirectQuery report in Power BI one of the first questions you need to ask is how long the SQL queries that Power BI generates take to run. This is a more complicated question to answer than you might think, though, and in this post I’ll explain why. I happen to […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/KTxbbByyABk/. The author is Chris WebbPremium Gen2 Preview important dates for autoscale coming up and timelines update This post first appeared at https://powerbi.microsoft.com/en-us/blog/premium-gen-2-timeline-update-capacity-size-enforcement-and-autoscale-charges-coming-up/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/premium-gen-2-timeline-update-capacity-size-enforcement-and-autoscale-charges-coming-up/. The author isOver the past few years, along with the high adoption rate of Power BI, also came the development of new tools by the Power BI community. Customers, partners, and individual users are contributing tools that improve the productivity of users creating models and reports in Power BI. It’s an evolution of a trend that started […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/community-tools-for-enterprise-powerbi-and-analysisservices/. The author isWe have an incredible lineup of customer story sessions at the upcoming Microsoft Business Applications Summit. Make sure to add these sessions to your backpack! You won’t want to miss them. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-amazing-power-bi-customer-stories-sessions-at-the-microsoft-business-applications-summit/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-amazing-power-bi-customer-stories-sessions-at-the-microsoft-business-applications-summit/. The author isOn-premises data gateway (standard and personal mode) release for April 2021 This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-april-2021-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-april-2021-update-is-now-available/. The author isI released an updated version of the ActiveCampaign free Power BI app on Microsoft AppSource. The new version includes a new page for contacts by tags. You can get the new app here. To review the new page, take a look at the embedded version of the app below that analyzes DataChant’s own ActiveCampaign and […]
This post first appeared at https://datachant.com/2021/04/26/activecampaign-app-v2/. The author is Gil RavivOne of the most common questions I get asked is “How can I use Power BI in DirectQuery mode on top of a REST API?”. This seems like a reasonable thing to do but almost everyone who tries it will fail, and in this post I will explain why. To answer this question we first […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/AEYFud_rO7I/. The author is Chris WebbJoin Arun Ulagaratchagan, Amir Netz and the Power BI team at Microsoft Business Applications Summit on May 4, 2021 for the Power BI two-part peek into the future. Hear the vision, learn about our journey, and see some amazing demos! This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-for-microsoft-business-applications-summit-may-4th-2021/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-for-microsoft-business-applications-summit-may-4th-2021/. The author isThe purpose of this article is to provide Power BI developers with a deeper understanding of the dependencies when updating data sources in a Power BI dataset through XMLA endpoints. Most importantly, Power BI maintains security-related data source information such as credentials and privacy settings outside the dataset, whereas Azure Analysis Services and SQL Server […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/using-xmla-endpoints-to-change-data-sources-in-a-power-bi-dataset/. The author isOver the years I have written a lot about Power BI/Power Query performance but it has always been in the context of loading data direct into datasets, not dataflows. A lot of cool things have been happening in dataflows recently, though, and now that Premium Per User has made Premium features to a much wider […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/WcXZe3-mYGY/. The author is Chris Webb