In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
Welcome Home: It’s not just a bombastic prog-metal song Continuous hiring mode In P3’s history, we’ve had a bit of a “reactive cyclical” hiring model. Demand for our services would grow, stretching us to the limits of staffing, so we’d add 1-2 new consultants. And those new consultants would instantly take us from “short of […]
This post first appeared at https://powerpivotpro.com/2021/01/p3-jobs-time-to-come-home/. The author is Rob CollieUsing Cloud App Security, it is possible to detect and control risky Power BI sessions as they occur, thus reducing the threat that arises when malicious actors try to access content and data. This post first appeared at https://powerbi.microsoft.com/en-us/blog/get-up-to-speed-with-power-bi-and-microsoft-cloud-app-security/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/get-up-to-speed-with-power-bi-and-microsoft-cloud-app-security/. The author isIt’s becoming increasingly common to want to import data from files stored in a data lake into Power BI. What’s the best way of doing this though? There are a bewildering number of options with different performance and cost characteristics and I don’t think anyone knows which one to choose. As a result I have […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/qcOgfOGa1po/. The author is Chris WebbLearn how to get started designing and implementing custom visuals for Power BI. Attendees will learn how to define the capabilities and data mappings for a custom visual and how to program D3-style data binding using categorical data from a Power BI dataset. The session also demonstrates how to extend a visual with custom properties […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-dev-camp-thursday-28-january-2021/. The author isLast December, I teamed up with my brother (who runs Daily Cookie, an email marketing boutique) to deliver the best-of-breed Power BI app for email marketing. DataChant and Daily Cookie proudly present the ActiveCampaign Email Marketing app. The app is available to download on Microsoft AppSource for free here. If you don’t have a Power […]
This post first appeared at https://datachant.com/2021/01/19/email-marketing-dashboard/. The author is Gil RavivSome interesting new Power Query functionality was released in the December release of Power BI Desktop (it’s also in the build of Excel I’m running) that didn’t get announced in the blog post but which will be useful for anyone using Excel as a data source. It is fully documented but I thought I’d blog […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/pn8SuVWCQkU/. The author is Chris WebbHandling Multiple URL Query Parameters With The Same Name Using Web.Contents In Power Query/Power BI
Some time ago I wrote a pair of popular posts about using the Query and RelativePath options of the Web.Contents function in Power Query and why they are important for dataset refresh. I have recently learned something extra about this subject which merits a new post, though: how to handle multiple URL query parameters with […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/lwJdvnz94EI/. The author is Chris WebbI am working on a new version of the COVID-19 Power BI app that includes a new country-level vaccination page. Until it is released on AppSource, here is a sneak peek: Credits: Data Source: Our World in Data on GitHub here. The vaccination picture was cropped from here (Both Creative Commons license) This post first […]
This post first appeared at https://datachant.com/2021/01/07/covid-19-global-vaccination/. The author is Gil RavivGeneral announcement of read/write XMLA endpoints in Power BI Premium. List of client tools that natively work with Power BI Premium. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-general-availability-of-read-write-xmla-endpoints-in-power-bi-premium/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-general-availability-of-read-write-xmla-endpoints-in-power-bi-premium/. The author isI’ve always thought it would be useful if we could run queries against AAS or Power BI via a simple REST API and I’ve just come across a really nice sample project created by one of my colleagues at Microsoft, David Browne, that allows you to do just that. You can find it here: https://github.com/microsoft/azure-analysis-services-http-sample […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/3YVRDVEUsdU/. The author is Chris WebbHappy New Year! In honor of the new year, we have put together this video. Enjoy! This post first appeared at https://powerbi.microsoft.com/en-us/blog/happy-new-year/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/happy-new-year/. The author isEvery year, on the anniversary of the first-ever post on this blog, I write a post reflecting on what has happened to me professionally in the past year. While I’m not sure anyone really wants to look back on the events of 2020 there is a topic I’ve been intending to write about for some […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/8SstGnJceNk/. The author is Chris Webb2020 was a tough year, but Power Query users have prevailed. A few weeks ago I published this survey to assess the business impact of Power Query. The results are now published in this Power BI report. What we have learned? This post first appeared at https://datachant.com/2020/12/29/business-impact-of-power-query-survey-results/. The author is Gil RavivRead More
This post first appeared at https://datachant.com/2020/12/29/business-impact-of-power-query-survey-results/. The author is Gil RavivIf the title wasn’t enough to warn you, this post is only going to be of interest to M ultra-geeks and people using Power BI with Azure Data Explorer – and I know there aren’t many people in either group. However I thought the feature I’m going to show you in this post is so […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/uBVdm7G_pC8/. The author is Chris WebbWe’re excited to introduce a new way to quickly create reports in the Power BI service. Rather than downloading Power BI Desktop and importing the data, you’ll now be able to paste data straight into Power BI on the web and have visuals automatically generated for you. This post first appeared at https://powerbi.microsoft.com/en-us/blog/quickly-create-reports-power-bi-service/. The author is Read […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/quickly-create-reports-power-bi-service/. The author isWe’re excited to introduce a new datasets hub in the Power BI service and Power BI personal app in Teams. The datasets hub makes it easy to find, explore, and use the datasets in your organization. It provides information about the datasets as well as entry points for creating reports on top of those datasets […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-datasets-hub-preview/. The author isWhile the long-awaited small multiples feature that previewed in the December 2020 release is an obvious boost to Power BI’s data visualisation capabilities, did you know that you can use it to improve report performance too? Earlier this year I wrote blog posts showing how you can improve report performance by showing the same amount […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/t1-SmJoLAB4/. The author is Chris WebbWith the the latest Power BI Mobile apps release report consumers can view and understand anomalies directly from the mobile apps! This capability is available on all apps (iOS, Android, Windows), in all supported form factors (phone, tablet, iPad, and laptop/desktop, including Surface Hub). This post first appeared at https://powerbi.microsoft.com/en-us/blog/anomaly-detection-preview-is-now-supported-in-power-bi-mobile-apps/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/anomaly-detection-preview-is-now-supported-in-power-bi-mobile-apps/. The author isThe last update of 2020 is here! We know you are excited for this update, like a kid excited to open their presents. This update is our holiday present to you! So what is in the box? Read on to find out! This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/. The author iswe’re excited to announce the Preview availability of the Power Automate Dataflow connector along with templates and sample scenarios you can get started with right away. The new connector provides a new way to react to dataflow events to take action on dataflows. Combined with other Power Platform Products connectors and the 400+ connectors available […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-dataflows-power-automate-connector-public-preview/. The author is