Select Page

In The Trenches

With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS

With the availability of virtual machine images for SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) in Azure Marketplace, you can now more easily migrate your AS and RS BI solutions from on-premises to Azure! This is a great opportunity to move your multidimensional workloads closer to Power BI to reduce the […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/moving-on-premises-as-and-rs-bi-solutions-to-azure-and-closer-to-power-bi/. The author is 

Read More

Read More

We’re happy to introduce new admin settings in Power BI admin portal, which provide you more granular control over export options in Power BI, and extend export settings to control also export from paginated reports. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-export-settings-are-available-in-the-power-bi-admin-portal/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-export-settings-are-available-in-the-power-bi-admin-portal/. The author is 

Read More

Read More

This week a customer came to me with the following problem: they had scheduled the refresh of their dataset but their source data wasn’t always ready in time, so the old data was being loaded by mistake. The best solution here is to use some kind of external service (for example Power Automate) to poll […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Bb-P9uIXv4Y/. The author is Chris Webb

Read More

Read More

November install of gateway This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-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-november-2020-update-is-now-available/. The author is 

Read More

Read More

This blog post covers the latest updates for Power BI embedded analytics and Power BI visuals platform This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-november-2020-update/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-november-2020-update/. The author is 

Read More

Read More

I’ll leave it to other people to get worked up about things like Power BI Premium gen2 – what really gets me excited is a new Profiler event type. And indeed there is a new one to play with – Job Graph – that you can use to visualise Azure Analysis Services processing jobs (it’s […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/z-8FpiExyU0/. The author is Chris Webb

Read More

Read More

P3 continues to grow, and in the process, our needs grow, too – and not just in the Power Platform department. In particular, we’re an opinionated crew, and we have some things to tell the world. Things that we believe to be valuable. And we’re kinda bottlenecked right now – unable to project those ideas […]

This post first appeared at https://powerpivotpro.com/2020/11/hiring-three-new-roles-copywriter-designer-and-web-dev/. The author is Rob Collie

Read More

Read More

Yesterday, I joined the Southern California Power Platform User Group and talked about bad practices in Power BI. You are welcome to watch the recording. You can download the deck here and read other articles on this topic here. This post first appeared at https://datachant.com/2020/11/12/session-recording-bad-practices-in-power-bi/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2020/11/12/session-recording-bad-practices-in-power-bi/. The author is Gil Raviv

Read More

Read More

We have added lots of new capabilities to Power Query Online & Dataflows. This blog post provides a recap walkthrough of these new capabilities. This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-in-power-query-dataflows-november-2020/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-in-power-query-dataflows-november-2020/. The author is 

Read More

Read More

Our anomaly detection algorithm detects that there is an anomaly this month: Anomaly Detection is in preview! Also, we are announcing a preview of the new Field List and the Model View. We are adding a fan-favorite: the Visual Zoom Slider! In the Service, endorsements for datasets and dataflows are extended to reports and apps, […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-november-2020-feature-summary/. The author is 

Read More

Read More

 Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis.  With just a couple of clicks, you can easily find insights without slicing and dicing the data. This post first appeared at https://powerbi.microsoft.com/en-us/blog/anomaly-detection-preview/. The author is Read […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/anomaly-detection-preview/. The author is 

Read More

Read More

This post is an overview of ‘Visual Data Prep’ (Diagram View) which is going into Public Preview. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/. The author is 

Read More

Read More

In this camp session, we examine how to query and modify Power BI datasets using C# and the Tabular Object Model (TOM). The session will explain how to connect to a local data model running in Power BI Desktop as well as how to connect to data models in the Power BI Service through the […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-dev-camp-thursday-19-november-2020/. The author is 

Read More

Read More

We hare happy to share details about availability of enhanced Power BI premium using the next generation technology from Power BI This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-preview-availability-of-improved-analytics-with-next-generation-power-bi-premium/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-preview-availability-of-improved-analytics-with-next-generation-power-bi-premium/. The author is 

Read More

Read More

The date you have long waited for has finally arrived!  The public preview of Power BI Premium per user has been enabled in all public tenants that requested priority access, and will be rolling out to all tenants worldwide throughout the month of November.  Now, Power BI users have access to all the Power BI […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-premium-per-user-public-preview-now-available/. The author is 

Read More

Read More

Join us for a full day of training with Siva Harinath and Yana Berkovich from the Power BI content team! Learn about Power BI capabilities to enhance the data model for your business users. This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-training-advanced-data-modeling/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-training-advanced-data-modeling/. The author is 

Read More

Read More

Even though the documentation for dynamic M parameters does mention how to handle multi-select in the M code for your Power Query queries, I thought it would be useful to provide a detailed example of how to do this and explain what happens behind the scenes when you use multi-select. Once again I’m going to […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/-HfiBiz5jys/. The author is Chris Webb

Read More

Read More

We have several exciting updates rolling out this month for paginated reports as we get ready for the launch of the Premium per user public preview.  These updates include new paginated reports samples, in-product parameter updates and more. This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-report-november-2020-feature-summary/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-report-november-2020-feature-summary/. The author is 

Read More

Read More

Since last week’s blog post about dynamic M parameters generated so much interest, this week I thought I’d give you another example of something cool you can do with them when you’re using Azure Data Explorer (ADX) as a DirectQuery source in Power BI: geospatial analysis. Let’s say you work for a chain of supermarkets […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/RpR-8lqC51M/. The author is Chris Webb

Read More

Read More

With the continuing rise of the public cloud, many companies are now centralizing their data in massive cloud data warehouses and data lakes powered by storage services, such as Azure Data Lake Storage (ADLS). The challenge is to deliver insights on these data warehouses and data lakes rapidly and cost-efficiently. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dremio-a-seamless-bi-experience-for-cloud-data-lakes/. […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dremio-a-seamless-bi-experience-for-cloud-data-lakes/. The author is 

Read More

Read More

Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world

Blogroll