Select Page

In The Trenches

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

We’re excited to announce the availability of two new query histogram distribution charts. One is bucketed by query durations(ms) and the other is by query wait times(ms). Query histogram… This post first appeared at https://powerbi.microsoft.com/en-us/blog/premium-capacity-metrics-app-query-metrics-histogram-now-available/. The author is Read More

Read More

I’m at the PASS Summit this week, and in this morning’s keynote there was a demo of the newly-released Azure Data Studio  – a modern, cross-platform tool for managing and querying SQL Server, Azure SQL Database and other Azure data services (it’s carefully described as “complementary to” SQL Server Management Studio rather than a replacement […]

Read More

We’re excited to introduce Paginated report and Dataflow metrics in Power BI Premium Capacity Metrics app (version 1.8)! The app supports monitoring the health of your premium capacities, providing… This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-report-metrics-and-dataflow-metrics-now-available-in-premium-capacity-metrics-app/. The author is Read More

Read More

We are happy to announce on the availability of Power BI Premium Paginated Reports in Power BI Mobile apps. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-also-available-in-power-bi-mobile-apps-preview/. The author is Read More

Read More

In July, we first announced our plans to support SQL Server Reporting Services reports in Power BI, and later demonstrated this capability at the Microsoft Business Applications Summit. Today, we are thrilled to announce the initial public preview of this functionality is now available in Power BI Premium, allowing customers to view and interact with […]

Read More

In the modern BI world, data preparation is considered the most difficult, expensive, and time-consuming task, estimated by experts as taking 60%-80% of the time and cost of a typical analytics project. Some of the challenges in those projects include fragmented and incomplete data, complex system integration, business data without any structural consistency, and of […]

Read More

As organizations embrace a data culture to drive business decisions, they need an enterprise business intelligence platform that can meet their sophisticated needs – from self-service BI to full enterprise governance, from paginated reports to full interactive data exploration, and from small data sets to petabytes of data. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-delivers-dataflows-enterprise-reporting-and-major-updates-to-power-bi-desktop/. The author […]

Read More

I watched a video from Guy in a Cube’s Patrick featuring Marco Russo where they walked through an example using a technique to debug DAX measures using VAR/RETURN – I loved this! https://www.youtube.com/watch?v=9SV2VnYbgg4 The video made me recall another Blog… This post first appeared at https://powerpivotpro.com/2018/11/techniques-with-countrows/. The author is Krissy DyessRead More

Read More

We are now in the last quarter of the year and, as always, the Power BI team is saving the best for last. We rolled out some of our biggest features in the months of September and October. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-september-and-october-2018-feature-summary/. The author is Read More

Read More

There’s a new, as yet undocumented, option for the Web.Contents() M function that is only available for custom data connectors and not in Power BI Desktop: CredentialQueryOption. It does the same thing as the Query option, but it stops the values you are passing to the query parameter from being logged in Power BI’s diagnostic […]

Read More

This is a quick tip on automated testing with Power Query. I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For… This post first appeared at https://powerpivotpro.com/2018/11/automated-testing-with-power-query/. The author is Fred KaffenbergerRead More

Read More

Discuss the latest updates to Power BI embedding features offered through Azure and the Power BI Service This post first appeared at https://powerbi.microsoft.com/en-us/blog/11-6-november-update-for-power-bi-embedding-with-ted-pattison-and-the-microsoft-dev-team/. The author is Read More

Read More

SQL PASS Summit 2018 is here!  The Power BI team is going to have another strong presence at the Seattle Convention Center next week, and we can hardly wait to see you there. This post first appeared at https://powerbi.microsoft.com/en-us/blog/your-power-bi-guide-to-sql-pass-summit-2018/. The author is Read More

Read More

Power BI is an enigma.  On the surface Power BI is an alluring product that promises to change your world of data analytics for the better – and indeed it can and will.  But sitting just beneath the surface, hidden from view, is the reality that there are many things you must learn if you […]

Read More

If you are following me on social media, this video will not be new. Two days ago I received my print copy of the book. The book is real I was so excited about it, so I had to fool around and create this video. A journey of one year has ended. I would like […]

Read More

We are pleased to announce that the ability to export your Power BI reports to PowerPoint is now generally available This post first appeared at https://powerbi.microsoft.com/en-us/blog/export-to-powerpoint-is-now-generally-available-and-looking-ahead-at-what-s-coming-next/. The author is Read More

Read More

[Part 1 of this series can be found here and part 2 here] The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are there hundreds of Excel files being used as data sources for reports that you don’t know […]

Read More

I am happy to announce that Custom and Certified Connectors in Power BI are now generally available!OverviewAfter delivering the Power BI extensibility framework, our incredible community has… This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-custom-and-certified-connectors-for-power-bi/. The author is Read More

Read More

What do you get when you combine Power Query with Amazon Web Services? You get a powerful new data source for your business needs and open a world of analytics possibilities. I’ll have some of that! I am certainly not… This post first appeared at https://powerpivotpro.com/2018/10/connect-power-query-to-amazon-web-services-redshift-database/. The author is Doug BurkeRead More

Read More

Starting today, Power BI is expanding to four new regions, allowing customers to locate their Power BI deployments closer to their data sources, either in Azure or on-premises, thus enabling faster performance of data refresh and lower networking egress costs. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-power-bi-regions-in-india-australia-united-states/. The author is Read More

Read More