Power BI

Power BI MVP and crowd Favorite Avi Singh will be presenting: Building Impactful Financial Dashboards Using Microsoft Power BI Webinar 10/16

Visually Appealing Power BI Reports (@ExceleratorBI) So, You’re Getting a Data Warehouse for Power BI… (@PowerPivotPro) Power BI Developer community September update Deep dive in the organizational cu…

Recently I picked up an interesting request to transform the words in a column to proper case, but keep certain keywords like in a defined list. So let's transform text with exceptions:

Here is a technique you might consider if you need to split text down to individual words. This could be used to help count, rank or otherwise aggregate the words in some longer text. The approach det…

On October 25th, 1997, I attended a football (American) game in Lawrence, Kansas between the number 1 ranked Nebraska Cornhuskers and the Kansas Jayhawks. It was a cold and rainy night which, in addit…

Microsoft Flow – Copy files from SharePoint Online to a local PC I recently assisted a customer with an automated workflow through Microsoft Flow that copies files from a SharePoint Online site librar…

Certain M functions accept a Culture parameter that ensures the result is returned in the defined language, regardless of the language of the OS.

It is very difficult for an organisation to decide whether to buy Power BI Premium or to stick with Power BI Pro. Power BI Premium represents a big financial commitment, but how do you know whether…

At Microsoft Ignite, we announced several exciting new features coming to the new SharePoint admin center. Today we're excited to share that we’ll start to roll out these features worldwide later this month to organizations that have “Targeted release for everyone” turned on. What's coming in ...

This is a short post showing how to collect button clicks from an actionable email that contains an adaptive card. In http://www.msclouddeveloper.com/finishing-the-support-incident-scenario I show how to send back an adaptive card in an email. But I also say that I hadn't succeeded yet in using a

We're excited to announce that we've made it easier to discover the entry points for creating canvas and model-driven apps. We’ve taken away the mode switcher and brought both model-driven and…

What tool do you use for Analysis Services Tabular development? SSDT right, what else? Here is a little secret. I almost don’t use SSDT anymore, except for limited tasks, such as importing new tables …

App Dev Manager Om Chauhan demonstrates an approach for monitoring Flows and PowerApps to enable alerts or taking custom actions. What is Microsoft Flow? Flow is an online workflow service that enables you to work smarter and more efficiently by automating workflows across the most common apps and services. It’s a recommended solution for workflows...

Welcome to another week of the weekly Power BI RoundUp, I hope you enjoy catching up on the latest content below. Power BI – Power BI Preview Features in Action In this blog post by Chuck (Charles)…

Custom visuals bring great value to your organization. By using tailor-made visuals, enterprises can tell their own story and visualize data in the best way! In some organizations custom visuals are even more important – they might be necessary to convey specific data or insights unique to the organization, they may have special data requirements, or they may highlight private business methods. Such organizations need to develop their own custom visuals, using the Power BI opensource custom visuals framework. Or find a consultancy service offered by one of our partners. Where organization...

For me, a good data warehouse enables business pros to create reports without needing to think too much about the data model. Another benefit I see is the ability to deliver operational reports from transactional databases (ERP, CRM, financial systems). 5 Suggestions for aligning a data warehouse with Power BI.

One thing I often get asked is “How do I create good looking Power BI Reports?”. This is a very good question and unfortunately the answer is not straight forward. I like to think of the visual a…

At Microsoft Ignite 2018, James Phillips and I shared the main stage to showcase real stories from organizations leveraging Microsoft Business Applications to disrupt business as usual and innovate to…

In this video, Patrick introduces the Mashup Engine Query Monitor for Power BI Refresh. This is the MEQM! A report that can be useful to see SQL Server queries that Power BI issues during refresh. MEQM Files – https://github.com/guyinacube/demo-files/tree/master/video%20demos/MEQM

Recently, a client wanted to display pictures in Power BI using images saved in a database, but the image data was stored using a varbinary (max) data type column. Power BI can only display images if …

In many scenarios, you would want to enable certain columns as multi-select. In this blog, let’s look at an example on how to achieve this using PowerApps. Example: Let’s build a simple application…

In this blog, we will go over 10 tips that I find useful when building apps with PowerApps. They help me keep my app easy to read, debug and maintain. Hope you find them useful as well.

A common scenario when building apps is to enable deep linking into specific screens within your application. In the example below, we have a catalogue of devices that you can browse, look at the…

One of the new feature available in Flow & PowerApps is that Flow can easily return value(s) to PowerApps. This is very important because we can now easily use Flow as a business layer for PowerApps. …