Select Page

In The Trenches

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

In addition to the 20 tracks lead by the community, technical experts and Industry luminaries presenting at the upcoming Power Platform Summit in Amsterdam, the Microsoft Team will be there in full force presenting the Microsoft Power Series track– over 15 hours of deep dive and hands on content.  These sessions are included in both the  Power […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-power-series-at-the-2019-power-summit-europe/. The author is 

Read More

Read More

  “Can I tell you a secret? You might be a song blogwriter.” How long has it been since I’ve thrown out a movie quote?  Years, maybe?  It might have been that long.  And I must say, I had no… This post first appeared at https://powerpivotpro.com/2019/01/2019-called-it-wants-your-name-in-lights-guest-post-opps/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/01/2019-called-it-wants-your-name-in-lights-guest-post-opps/. The author is Rob Collie

Read More

Read More

Earlier last year, we announced bookmarking to be generally available in Power BI Desktop. Bookmarks are currently used by many report authors to share interesting insights, tell a story, and create intuitive navigation elements within a report. Since its introduction, one of the biggest requests we’ve consistently received from the Power BI community is to […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-personal-bookmarks-in-the-power-bi-service/. The author is 

Read More

Read More

Happy new year everyone! We are kicking off the new year with an update to Power BI dataflows, focused on the dataflows editor. Power BI dataflows was introduced to public preview in November, and was well received. Since then we’ve been working to increase dataflows adoption even more by introducing new and exciting features. Today […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/. The author is 

Read More

Read More

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

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

Read More

Read More

In this week’s webinar Ted Pattison will be covering how to develop Custom Visuals for Power BI. Power BI has supported the development of custom visuals since its initial release. However, the custom visuals platform has been constantly evolving and has recently been updated to support dynamic module loading which makes it possible to develop […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/1-17-2019-webinar-updates-for-developing-custom-visuals-for-power-bi-by-ted-pattison/. The author is 

Read More

Read More

This is the longest running blog post series I have on my website.  Why does Power Pivot Crash so often and what can I do about it?  I have three previous articles that you can read in the links below Original post (Oct 16): Does the Power Pivot Excel Add In Crash for You? Follow […]

This post first appeared at https://exceleratorbi.com.au/a-further-final-update-from-seattle/. The author is Matt Allington

Read More

Read More

I have already blogged in great detail many times about Power BI/Power Query data privacy settings (see this series for example) but there’s always something new to learn. Recently I was asked a question by Ian Eckert about how Power BI handles data privacy for cloud or web-based data sources after a dataset has been […]

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

Read More

Read More

A weekend challenge I hope you are enjoying your second weekend of 2019. I was helping a friend recently figuring out the following data challenge: This post first appeared at https://datachant.com/2019/01/12/the-fill-down-hierarchies-challenge/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2019/01/12/the-fill-down-hierarchies-challenge/. The author is Gil Raviv

Read More

Read More

If you’re learning Power BI and you want to deepen your understanding of its data transformation and loading functionality, the Power Query engine and the M language, I’m doing one-day pre-conference seminars on this subject at three conferences over the next few months: SQLKonferenz in Darmstadt, Germany, 19-21 February 2019 (see here for more details) […]

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

Read More

Read More

Power BI already has an easy way to embed Power BI reports into public websites with Publish to web and to secure SharePoint Online pages with the Power BI web part. However, embedding content into internal sites required advanced coding skills. Now, with the new secure Embed option, you can easily integrate your report with […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/easily-embed-secure-power-bi-reports-in-your-internal-portals-or-websites/. The author is 

Read More

Read More

There are quite a few different common business scenarios where you get data in the form of a file on a regular basis.  The 3 common patterns I use most often are. Each day/month/year you get a new file containing incremental data.  All the data in all the files need to be combined and loaded. […]

This post first appeared at https://exceleratorbi.com.au/combine-all-sheets-in-a-workbook-with-power-query/. The author is Matt Allington

Read More

Read More

Happy New Year 2019 to our P3 readers! For the new year, I have a question for you: What do you think of when you hear the word “Flow”? For me, I immediately think of “Flo” from Progressive – someone… This post first appeared at https://powerpivotpro.com/2019/01/finding-the-flow-a-beginners-guide-to-microsoft-flow/. The author is Krissy DyessRead More

This post first appeared at https://powerpivotpro.com/2019/01/finding-the-flow-a-beginners-guide-to-microsoft-flow/. The author is Krissy Dyess

Read More

Read More

Join Charles Sterling and Power BI MVP Leila Etaati, in this webinar as she covers how Text Recognition (OCR) using Cognitive Service, Microsoft Flow, and Power Apps. Webinar details: Cognitive service is a pre-build AI tool that can be used with Microsoft Flow and Power Apps to create intelligence applications in an hour. In this […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/jan-10-webinar-text-recognition-ocr-using-cognitive-service-microsoft-flow-and-power-apps-by-leila-etaati/. The author is 

Read More

Read More

I’m pleased to announce that the updated version of my Power BI video training course is now available via my friends at Project Botticelli. You can find out more and purchase it here: https://projectbotticelli.com/power-bi-desktop-and-cloud-course-video-tutorial?pk_campaign=cwblog2019&code=crossjoin This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/kz8haXgsdM8/. The author is Chris WebbRead More

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

Read More

Read More

You have millions of rows of data stored in your data warehouse, you have it accessible and available for business users and report users, but how do you effectively tell a story using all that data? How do you unlock the secrets and the potential your data has? In this session Power BI MVP, Ruth […]

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

Read More

Read More

A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it can’t be that new) and which is potentially important for the performance of data refresh and of […]

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

Read More

Read More

It’s all the Power BI content you’ve come to expect from Microsoft team members, MVPs, Champions, and Subject Matter experts but this year’s Power Platform World Tour will now include PowerApps and Microsoft Flow content. Power Platform World Tour will bring together thousands of users in cities all around the world to learn and network […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/the-power-bi-world-tour-is-back-in-2019-as-the-power-platform-world-tour/. The author is 

Read More

Read More

Late in 2018 there was a new Power Query book written by Gil Raviv called Collect, Combine and Transform Data Using Power Query in Excel and Power BI.  That’s a bit of a mouthful actually; maybe the title was influenced by the same people that call Power Query “Get and Transform” in the Excel menu?!   […]

This post first appeared at https://exceleratorbi.com.au/best-book-for-learning-the-m-language/. The author is Matt Allington

Read More

Read More

Happy New Year ! With over 150 features released, 2018 has been a prolific year for Power BI Desktop! To cap off this successful year, our team put together a fun video, showcasing our pick for the 5 favorite releases of 2018: Report page tooltips [March] Web by example [May] Composite models [July] + aggregations [September] […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/happy-new-year-from-power-bi-desktop-2/. 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