Power BI

Have you ever wanted to do a specific type of filter that might be too specific to do with just the regular filter drop down or even the advanced filter operations in Excel? Let me give you an example…

One advantage of data warehouses is the ability to have data from multiple data sources available for analysis without being constrained by the availability and performance characteristics of those da…

The Common Data Model provides semantic consistency to data in Microsoft Azure Data Lake Storage Gen2 Preview.

Rather than a measure, this is a python-tool that generates DAX code to implement a pre-trained neural network (or linear/logistic regression) for prediction. https://github.com/maka89/dax_neuralnet

Power BI Service and Mobile September & October Feature Summary Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop Public Preview of Paginated Reports in Power BI…

Refreshing data in Power BI from SQL Server Read-only or Secondary Replica’s (@GilbertQue) Quick Measures in Power BI: You don’t have to write DAX!? (@Rad_Reza) How to use A SKU’s to try out Paginated…

Power BI Visual Usability Checklist (@mmarie) Get the most out of Power Query in Power BI Dataflows (@diverdown1964) Analysis Services is 20 years old! Announcing new AI Capabilities for Power BI to make AI Accessible for Everyone Power BI Desktop November 2018 Feature Summary BONUS ITEMS: Tableau to Power BI: Highlighting with Set Actions (@dataveld) […]

We've added a new, rich HTML-based text editor that helps you write HTML-based emails and more. This editor allows you to customize the font, use bold, italic or underline, customize the color, and create lists or links. Partners have also released four new connectors: Imprezian360-CRM, Encodian, Soft1 , and <a href="https://flow.microsoft.com/connecto...

With data lakes becoming very popular, a common question I have been hearing often from customers is, “Should I load structured/relational data into my data lake?”. I talked about this…

Hi, I use a Personal Gateway to auto-update my Datasets. One data source - Sharepoint, is now throwing an error. I can log into Sharepoint fine normally, and it refreshes in my local Power BI file, but the online credentials suddenly don't work. Oddly, when I check t...

Hi I have installed an on-premisis gateway- It is online and all connections are online too: I am using this gateway to refresh, and everything seems fine: But when I try to refresh, I get an error, saying that my PERSONAL gateway is offline: Everything worked until November 8th. I ha...

Our data gateway has been occasionally failing scheduled refreshes with 'gateway unreachable' errors which I'm fairly confident are because the machine was taxed by other data processing tasks, so to remedy I've added a second data gateway to the same cluster and set the cluster to distribute querie...

If you’ve been reading this blog, you already know a few things: Power BI includes a capability for self-service data preparation called “dataflows” Dataflows include computed ent…

Read this blog post to create a sample PowerApps canvas app which uses an Azure function along with Azure Table Storage via custom connectors protected by Azure AD

In Chapter 12 of my book, I published detailed walkthroughs that cover Translator Text API, Sentiment Analysis, Key Phrase extraction and the detection of languages using Cognitive Services. As I worked on the chapter, I realized that it will make sense to prepare a template that will streamline all of these APIs together to address …

Q: What are Power BI dataflows? A: Dataflows are a capability in Power BI for self-service ETL and data preparation that enable analysts and business users to define and share reusable data entitie…

Structure is a foundational element to much of what designers of analytical systems and solutions do – but it can be easy to lose sight of the “Why?” of it all. If we don’t need to face the difficult task of imposing structure on our data to analyze it, then what do we gain by doing so?

The dimensional model has been around for quite some time and continues to confer benefits to its adherents today. Made popular by Ralph Kimball years ago, the dimensional model was central to Kimball’s proscribed approach to data warehouse architecture.

Have you ever wanted to extract information from a web page to use in a calculation, or as a reference for something else you may be working on? I have Use Microsoft Excel Power Query to scrape engine…

When using PowerApps multi-line text inputs, behavior on line breaks is not always consistent. You may have also noticed that your Microsoft Flow approval comments will not (always) return line breaks…

I am often working on datasets where there is more than one condition for a conditional column. And whilst the GUI based Conditional column is really good, it currently does not have the capability…

In this article, I am going to explain how to send a mail on button click in PowerApps through Microsoft Flow. This article will help us to how to create flows , trigger from PowerApps, pass the dynamic values to flows etc.

While Power BI has a lot of great functionality for filtering the data that appears in a visual using visual-level filters there are going to be situations where you need more control over how filteri…

Theme options in Word, Excel, and PowerPoint have been available for a while now. They give your content a consistent set of fonts, colours and effects. Microsoft has identified this feature was badly…

Last year (in april 2017) I mentioned that I was a little bit worried that Microsoft Flow didn’t provide state machines workflows; I also mentioned that an easy way to achieve this was a loop…

I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M connector, it is available in the OLE DB connector. NOTE: This could potentially be used for a whole host ...