In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
With all the craziness in our lives due to coronavirus, the reliance today on facts is more important than ever. To help you stay safe I thought you would appreciate this tutorial to learn how you can build your own reliable Power BI report that can analyze the confirmed infections, recovery and death rates of […]
This post first appeared at https://datachant.com/2020/03/18/covid-19-build-your-own-power-bi-dashboard/. The author is Gil RavivWe’re excited to announce the full Paginated Reports in a Day course is now available to view online at no cost! This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-in-a-day-training-is-now-available-free-online/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-in-a-day-training-is-now-available-free-online/. The author isMissed the Arun ‘Triple A’ event or want to revisit it? We’ve got you covered! This post first appeared at https://powerbi.microsoft.com/en-us/blog/arun-triple-a-event-video-qa-and-slides/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/arun-triple-a-event-video-qa-and-slides/. The author isBe the first to experience the new innovations across Microsoft Power Platform and Dynamics 365 on April 2 at the Microsoft Business Applications Virtual Launch Event—a free virtual event for everyone from app users to IT professionals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/were-revealing-whats-next-for-power-bi/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/were-revealing-whats-next-for-power-bi/. The author isMarch Gateway release This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-march-2020-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-march-2020-update-is-now-available/. The author isBack in 2018, when I wrote a detailed post on how to create nested display folders for measures in Power BI, I mentioned that unlike in Analysis Services it was not possible to make a Power BI measure appear in two or more folders simultaneously. The other day on Twitter Deepak Agrawal pointed out that […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/AKl9bNacmpo/. The author is Chris WebbWe’re All Going to Keep Working, But We’re Going to be Smart About It Now is the Time I’ve been mentally working on this post for nearly two weeks. “Post it too soon,” I told myself, “and you’ll look like… This post first appeared at https://powerpivotpro.com/2020/03/welcome-to-the-new-normal/. The author is Rob CollieRead More
This post first appeared at https://powerpivotpro.com/2020/03/welcome-to-the-new-normal/. The author is Rob CollieCreate custom visuals using R, JSON scripts and Charticulator. This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-dataflows-webinar-mar-12-1100am-noon-pst/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-dataflows-webinar-mar-12-1100am-noon-pst/. The author isWe have great updates this month! We are releasing new button actions, multi-column sort for tables, dual axis for line chart, a search for the filter pane, updates to decomposition tree, and much more! We are also releasing a preview of an enhanced dataset metadata feature, which will be foundational for XMLA read/write and for […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/. The author isToday, I’m excited to announce that we’re releasing a new, revamped search experience that allows users to search across all the content they have access to from any page in the product! This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-a-new-revamped-search-experience-in-the-power-bi-service/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-a-new-revamped-search-experience-in-the-power-bi-service/. The author isIn my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn’t give you any examples of why this might be useful. In this post I’ll show you how you can use a Profiler trace to visualise all the queries run by a Power BI […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/g1LanrAaqt8/. The author is Chris WebbFind out what happened in the Power BI Community in February. This post first appeared at https://powerbi.microsoft.com/en-us/blog/february-2020-community-highlights/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/february-2020-community-highlights/. The author isIntroducing Interactions Setting, which lets you configure how to interact with reports in Power BI mobile apps. Including docking report footer and enabling multi-select! This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-mobile-you-are-in-control/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-mobile-you-are-in-control/. The author isI have delivered Power BI training at a number of universities over the last 6 months, and a few of the participants asked me the same question. “What is the best way to add semesters … Adding Semesters to a Calendar in Power BI Read More This post first appeared at https://exceleratorbi.com.au/adding-semesters-calendar-power-bi/. The author is Matt AllingtonRead […]
This post first appeared at https://exceleratorbi.com.au/adding-semesters-calendar-power-bi/. The author is Matt AllingtonWe are thrilled to announce an additional layer of capabilities, allowing you to export a Power BI report by using a REST call, to the following file formats: PDF, PPTX (PowerPoint) and PNG. This post first appeared at https://powerbi.microsoft.com/en-us/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest-api/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest-api/. The author isIn a recent post, Matt discussed how to extract data from complex websites with Power BI using the New Web Table Inference capability of Power Query. This article is an extension of those ideas, revealing … Scraping data from JavaScript web sites with Power Query Read More This post first appeared at https://exceleratorbi.com.au/scraping-data-from-javascript-web-sites-with-power-query/. The author is Jason […]
This post first appeared at https://exceleratorbi.com.au/scraping-data-from-javascript-web-sites-with-power-query/. The author is Jason CockingtonWe are starting an exciting new contest this March! Starting today, March 2nd, 2020, we are asking all of you to come up with a “Better Together” T-shirt design. This post first appeared at https://powerbi.microsoft.com/en-us/blog/better-together-t-shirt-design-contest/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/better-together-t-shirt-design-contest/. The author isOver the past few months, we’ve hosted three Power BI “Triple A” Community events. Find out how you can watch the recordings. This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-power-bi-triple-a-event-videos-are-now-live/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-power-bi-triple-a-event-videos-are-now-live/. The author isBack in December when I wrote a series of posts on testing the performance of Power BI reports in the browser, I mentioned that it was important to test in the browser because some aspects of the performance of a report may be different there compared to in Power BI Desktop. Following on from this, […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/tQ3HlFOO7xA/. The author is Chris WebbFollow @gilra The Community Summit was postponed to June 29 – July 2 due to the Coronavirus worldwide concerns. So, I have plenty of time to prepare for my session. I don’t like to keep things in the oven for a long time – so I decided to share with you a few of my […]
This post first appeared at https://datachant.com/2020/02/29/meet-the-bad-practice-power-bi-astronaut/. The author is Gil Raviv