Select Page

In The Trenches

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

E-mail subscriptions is one of the key features used by millions of SQL Server Reporting Services customers today. Our latest release for “New Feature Friday” is the support of Paginated Reports in e-mail subscriptions in Power BI. Now, for the first time, you can schedule an e-mail subscription with a PDF attachment of your full […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/e-mail-subscriptions-for-paginated-reports-is-now-available/. The author is 

Read More

Read More

Just a short post today to share with you a permanent fix to something that has been annoying me (maybe you too – but then again I am easily annoyed 🙂 ).  Edit:  read the comments below from Amir Netz from Microsoft where he explains why this change was made Vertically Position Report Canvas in […]

This post first appeared at https://exceleratorbi.com.au/reposition-report-canvas-in-power-bi-desktop/. The author is Matt Allington

Read More

Read More

Let’s pick back up where we left off last week and continue building the workflow and finishing up our PowerApp! Create a Flow At this point, we have a functioning app that stores data in a SharePoint list. The Action… This post first appeared at https://powerpivotpro.com/2019/04/putting-it-all-together-part-2/. The author is Michael McKinleyRead More

This post first appeared at https://powerpivotpro.com/2019/04/putting-it-all-together-part-2/. The author is Michael McKinley

Read More

Read More

This is the first blog post in a series of posts that I plan to publish and share some of my demos that I presented during the Power Platform World Tour in Chicago last week (April 9-10, 2019). Follow @gilra This post first appeared at https://datachant.com/2019/04/16/be-a-power-platform-jedi-how-to-run-a-book-raffle/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2019/04/16/be-a-power-platform-jedi-how-to-run-a-book-raffle/. The author is Gil Raviv

Read More

Read More

This is the third article in my series about how to make Power BI Premium more affordable for small to medium sized enterprises (SMEs).  In my first article I explained the problem and the logic behind how to configure a workable solution. In my second article I provided step by step instructions on how to […]

This post first appeared at https://exceleratorbi.com.au/scale-your-power-bi-capacity-up-down/. The author is Matt Allington

Read More

Read More

BI Survey 19

Apr 15, 2019 | Chris Webb

The BI Survey is the largest annual survey of BI users in the world, and every year I get a free copy of the results (which are always very interesting) in return for publicising it here on my blog. If you take part, you’ll also get a summary of the results and be entered into […]

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

Read More

Read More

Power BI Live Connect reports allow the dataset to be stored in Azure Analysis Services (Azure AS) or SQL Server Analysis Services (SSAS) while the report itself resides in the Power BI service. Report interactivity can be enhanced by Power BI maintaining caches of dashboard tile data and report data for initial load. However, enterprise […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/governance-settings-for-power-bi-cache-refreshes-from-azure-analysis-services/. The author is 

Read More

Read More

With Power BI apps, you can create collections of dashboards and reports and publish these apps to your whole organization or to specific people or groups.  For the second post in our series we’re calling “New Feature Friday”, we’re pleased to announce that Paginated Reports can now be published from your workspaces as part of […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-now-supported-in-apps-in-power-bi/. The author is 

Read More

Read More

In Power BI datasets that combine data from multiple data sources in a single M query, privacy levels define a how the data sources are isolated from each other. Restrictive isolation levels block data from being exchanged with other data sources, which can reduce functionality and impact performance but ensures that sensitive data does not […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/privacy-levels-for-cloud-data-sources/. The author is 

Read More

Read More

April is an exciting month for Power BI Desktop! Our April update has major updates across the entire product. This release adds the ability to define the titles of your visuals and the URLs of your buttons based on DAX expressions, which is only our first step towards making every property of a visual expression-based. […]

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

Read More

Read More

It’s time again to recap all the features and announcements we made in the month of March. Premium Multi-Geo General Availability Users outside your organization can edit and manage content with Azure AD B2B On-premises data gateway March update Public preview of XMLA endpoint Slideshow in presentation mode for Windows Power BI app Updates to […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-march-2019-feature-summary/. The author is 

Read More

Read More

Here’s yet another entry in the list of useful things I learned from Ehren von Lehe on the Power Query MSDN forum: Table.Buffer() does not buffer nested table, record or list values inside the cells of a table. From this thread: Buffering is shallow. It will force the evaluation of any scalar cell values, but […]

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

Read More

Read More

By now, we’ve all seen Microsoft’s rebranding of Power BI, PowerApps, and Flow into the Power Platform, a set of tools for the citizen developer to analyze data, take action from that data, and, ultimately, solve problems. No doubt, you’ve… This post first appeared at https://powerpivotpro.com/2019/04/putting-it-all-together-part-1/. The author is Michael McKinleyRead More

This post first appeared at https://powerpivotpro.com/2019/04/putting-it-all-together-part-1/. The author is Michael McKinley

Read More

Read More

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”.  Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use the DAX language.  Here are a couple of examples Total Sales Syntax Sugar = SUM(Sales[ExtendedAmount]) Total Sales Full Syntax = […]

This post first appeared at https://exceleratorbi.com.au/simple-filters-and-syntax-sugar-in-dax/. The author is Matt Allington

Read More

Read More

In our February blog, we touched on how Power BI and Azure SQL Data Warehouse together provide customers with unmatched analytics capabilities that enable fast, interactive analysis across petabytes of data – we call it petabyte-scale analytics.     Today we want to call attention to the exciting news that Azure SQL Data Warehouse has […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/industry-benchmark-recognizes-microsofts-unmatched-analytics/. The author is 

Read More

Read More

Power BI is now available in two new regions, allowing customers to locate their Power BI deployments closer to their data sources, either in Azure or on-premises, enabling faster performance of data refresh and lower networking egress costs.  The new regions are: France Central Korea Central With the addition of these two new regions, Power […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-power-bi-regions-in-france-and-in-korea/. The author is 

Read More

Read More

We’re so excited to announce Alexis Ohanian as our special guest keynote speaker for Microsoft Business Applications Summit, coming to Atlanta, Georgia June 10 – 11, 2019. Dubbed “Mayor of the Internet” by Forbes, Ohanian co-founded Reddit in 2005. He sold the site to Condé Nast in 2006, but returned in 2015 as executive chair […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/mayor-of-the-internet-alexis-ohanian-to-keynote-microsoft-business-applications-summit/. The author is 

Read More

Read More

To kick off our series of posts this month we’re calling “New Feature Friday”, we’re pleased to announce the initial release of Power BI Report Builder, the latest companion application for Power BI that lets you author Paginated Reports. It is a free, standalone Windows Desktop application that can be downloaded from the Power BI […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-report-builder-now-available/. The author is 

Read More

Read More

Automated ML and Cognitive Services in Power BI enables compelling new analytics scenarios – with cognitive services you can perform sentiment analysis, pull key phrases from unstructured text, tag images with their content and more! And with Automated ML you can build your own binary prediction, classification, and regression machine learning models on your historical […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/enabling-cognitive-services-and-automated-ml-in-your-power-bi-premium-subscription/. The author is 

Read More

Read More

I’m happy to announce that starting today, the New Workspace Experience has reached General Availability (GA). With the new workspace experience, Power BI workspace admins can use security groups to manage access to workspaces, enable BI teams to create workspaces without needing to create an Office 365 Group, and to provide granular workspace roles to […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-new-workspace-experience-general-availability-ga/. The author is 

Read More

Read More