Power BI

Level: Intermediate I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart. Now I am not professing to be a …

Now that you know about the dimension and fact tables, it is time to talk about one of the most important concepts of modeling. You might have heard about dimensional modeling or star schema, but you may have vague ideas about what it is, or alternatively, you might have used it, but not sure if…

We’re excited to announce the release of new app navigation experiences that give reporting teams the power to customize navigation for end users, so they can find content quickly and understand the relationships between different reports and dashboards. We’ve also sprinkled in several important new features to help app authors create supportable apps that delight … Continue reading “Designing custom navigation for Power BI apps is now available”

We are super excited to announce that we will be starting to roll out Dual Write (Preview) to all our customers! Huge thanks to customers and partners from our Insider program without whom we wouldn’t have reached so far! It has been a great journey with lots of learning along the way. We have just … Continue reading “Announcing Dual Write Preview”

An exploration of embedding files in a Power BI dataset, I got the idea when I was doing some reading about Power BI, stumbled upon an artice about embedding images at this link: https://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html which made me think about coupling files, or ...

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup138 Tech video: https://guyinacu.be/relativedates Channel Update: https://guyinacu.be/channelupdatemay2019 What’s in my backpack: https://guyinacu.be/50kthankyou Source Automatic time intelligence in Power BI (@FerrariAlberto) NEW GATEWAY MONITORING (@BrettPowell76) Creating a Slicer Pop-Out Window with Bookmarks in Power BI (@HavensBI) Trusted Third Party Connectors for Power BI Power […]

This is bananas. I hadn't seen the source article, thanks for posting this sample. I was able to grab your component from Github and try it in minutes. Time to get good with SVG math I guess...

This blog post shows how you can use Text.ReplaceAll in Power Query to replace multiple words at once.

Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html https:…

The DAX Debugger measure shows details of the filter arguments from your CALCULATE measure if you have to debug it. M-function creates the code automaticall

One way to make your Microsoft Forms Pro survey interactive and dynamic is to use branching rules. In this post we will look at how to do this.

We have an exciting release this month. On top of incremental improvements for several of our recent released features, such as the key influencers visual and our new filter pane, we also have a ne…

Microsoft Business Applications Summit June 10 – 11 in Atlanta, Georgia is almost here and you have one more reason to attend year…A chance to meet the community super stars. We know, one of the pr…

I have recently started to experiment with Forms Pro, in this post I will explain my initial tests and provide a few observations on my opinions so far.

If you’ve used Microsoft Forms, you’ll know it’s pretty straightforward to use and provides you with a quick tool to create surveys and forms to send to people. Enter Microsoft Forms Pro, which is currently in PREVIEW mode, and it’s looking more interesting. Given the name, there will most likely be a cost associated in...

What is the maximum length of a text value in Power BI? It turns out that this is a more complex question than you might think! The maximum length of a text value that the Power Query engine can lo…

[Blog] How to solve recursion problem in Power BI using Power Query: Provisional stock data example by @JoanaVBarbosa

One of the primary reasons people go to conferences is to meet the presenters. At the Microsoft Business Applications Summit and the Microsoft presenters we have an entire “Ask the Experts” experience to make this easy. For community presenters we have created a community lounge and will be schedu...

Last week, I had a conversation on twitter about dealing with corporate color palettes that don’t work well for data visualization. Usually, this happens because corporate palettes are design…

Now that tax season is over, are you ready to see how your contributions are helping the government run? As it did in 2017 and 2018, USAFacts published a 10-K Report using Microsoft Power BI to show a comprehensive view of US federal, state and local governments’ revenues and expenditures. The not-for-profit, non-partisan institute—funded by former Microsoft … Continue reading “Through Power BI, USAFacts Explores Government Financial Data In Latest Report”

Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a little DAX into Power BI Desktop to get this going!

The 4th part of the blog series covers what happens when Row Level Security is applied to a Power BI Premium report and if there is any effect.

PowerApps brings you lots of built-in controls and ways to visualize your data with just a few clicks. Sometimes, however, you might want to build custom visualizations that are not quite achievable w…

Using Power BI is simple, however, using it properly, needs a good architecture. In a multi-developer tenant, the architecture of a Power BI implementation should allow multiple developers to work on …

<p>Importing components from a local file is no longer the only way to share! With this update, you can share components using cloud apps. This feature is currently rolling out and it will…

This is the full definition fo the new Table.ContainsAnywhere function in Power Query. It covers optoins for search lists, case sensitivity, partial match..

You should master records in M/ Power Query, in order to become an M ninja. This post shows you all the basic concepts behind this value type.

Learn How to create a template to Reconcile Accounts Using Power Query for Excel. [with Video, Learn and Earn Activity and Workbook to download]

Mike Allen Systems - Doing Smarter Things With IT -