Power BI

You might have wondered that there is no DAX Quarter function in Power BI. Here in this short blog post, I explain some easy methods for calculating quarter. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. Sample Data To start this example, you can open…

Stock-type indicators are more complex to calculate than purely additive-type indicators. The most important point to consider is that each calculation has its pro and cons, and choosing the “best” approach will depend on these parameters.

Educational PowerApps videos and webinars new for the month of September

Want to migrate your custom connectors between environments? Now you’re able to move multiple custom connectors along with Canvas apps, Flows, and CDS customizations in a single package.

Patrick looks at native query and why you should be careful when using it in Power BI. He looks at what native query is, what to consider when using it, and how to monitor what query folding, in Power…

<p>If you are part of a larger team and you were wondering how you can enable collaborative development, this blog post is for you.</p>

When I start developing a new flow there are a few things that I put in place first. For me Microsoft Flow development all starts with making the process robust. Therefore I start with the try-catch p…

When you think as a code developer and you start with Microsoft Flow there will be a few patterns that you miss. In a first attempt to make every developer welcome, I developed the Try, Catch , Fin…

If you find yourself clicking the same button in the Power BI Desktop you might find this little tip useful. When you right click a button in the ribbon – you can add it to the Quick Access Toolbar…

Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very…

If you have been watching Power BI news recently, you know that Power BI fields now support custom formatting. In this short blog article, I am going to explain how to use this feature to achieve your custom formatting. You can do things like showing () for negative values, showing custom date/time formats, and etc.…

Need dual Y-axis on a line chart in Power BI? Then this tutorial is for you. Learn how to make a no-code custom visual for a dual y-axis line chart.

When you work on real-world projects in power BI, you would probably have different environments Like DEV, UAT, Pre-Prod and Prod. It is important for you and your audience to know what the data is coming from. Am I looking at Dev or UAT data or I am actually looking at real data in Production … Continue reading Good Practice: Always Display the Reporting Environment

Since the release of Power BI Template Apps, more than 50 new apps have joined the marketplace. It’s about time we would be able to search for template apps in a new way – in our own Power BI report that can be installed as a Template App – and not just by searching for …

You’ll notice one of our exciting updates right away when creating new reports with the September update of Power BI Desktop, a new, modern default theme! Not only do we have a new default theme, but we’ve more than doubled the number of built-in theme options for your report. If you’re a theme author, potentially more exciting are the updates to our theme JSON format which make it much quicker and easier for you to create your own custom themes that significantly change the look and feel of your report. Thanks to an intern project, we’re also releasing a frequently ...

Patrick shows you how you can clear the Power BI Desktop model cache when troubleshooting DAX performance.

See how you can use SharePoint Column Formatting to open a stand-alone PowerApps Canvas app connected to SharePoint data directly from the list.

This blog post shows how to use the Power BI On-Premise Data Gateway to stream data immediately instead of having to wait for it to start streaming

The first of an industry best practices series is by PowerApps MVPs like Ike Ellis where he highlights how you can create a solution that enables a mobile sales force to update their own Power BI reports.

When asked what content our blog readers and video viewers would like to see more of the most oft requested topic is “Industry Best Practices”. With that in mind we will be starting a s…

This post shows you how to use Power BI drillthrough filters & how to reset them to either display all data or to select a new item to filter.

In this post covers building an AI Builder object detect model by creating a list of items, upload images, tag each image and then train the model.

Have you ever wondered why some videogames and other data visualizations that you see on your daily basis have cooler designs than your business reports? Let's discover why.

In Shabnam Watson’s recent blog post on a bug she found when trying to create a Live connection from Power BI to Analysis Services she mentioned that the AutoSetDefaultInitialCatalog server propert…

In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query.

The PowerApps developers have definitely made up for lost time being at the Microsoft Business Applications Summit shipping over 19 features this month! While all the PowerApps developers went above and beyond the Unified Interface team really delivered the goods with 8 suites of enhancements (with each suite containing multiple features!). If you aren’t familiar … Continue reading “August 2019 updates for Microsoft PowerApps”

Reading Time: 2 minutes If you use Power BI Desktop regularly, you might notice an occasional reference to CefSharp. Unless you’re in web or application development or already familiar with Chromium, the following general information could be helpful. You are probably familiar with the popular web browser Google Chrome. The Chrome browser is based on Chromium, an open-source project…

It is possible to rename all of the columns in a Power BI table at once using some M Language tricks that anyone can learn. Click for full details.