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 isWe’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 isThis 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 WebbNovember 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 isThis 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 isI’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 WebbP3 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 CollieYesterday, 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 RavivWe 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 isOur 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 isAnomaly 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 isThis 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 isIn 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 isWe 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 isThe 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 isJoin 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 isEven 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 WebbWe 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 isSince 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 WebbWith 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