Power BI

This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Power BI offers the Au

Fact tables are the core of analysis in a data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in one big table. In this article, you will learn about the fact table, and how it positioned in a data model, you will also learn how…

Two years ago I wrote an article on how to export data from Power BI Desktop to an SQL database. Now there is another way which Power Query can use directly in SSIS.

Power BI uses ML.NET to help users identify key influencers and customer segments so that they can understand the factors that drive their business metrics.

This article shows how to build a basic date table using a calculated table and DAX. A date table is required for most time intelligence calculations such

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup137 2 Minute Tuesday: https://guyinacu.be/multiselecttitles Patrick’s tech video: https://guyinacu…

Mike Allen Systems - Doing Smarter Things With IT -

April was packed full of new capabilities for Power BI. Thank you for the ongoing support and feedback – we couldn’t have done it without you. Here’s a quick rundown of everything we announced last month: Power BI dataflows GA Q&A update for dashboards New workspaces experience GA Paginated Report Builder New Power BI regions … Continue reading “Power BI Service and Mobile April 2019 feature summary”

Another week, another event done. This time it was SQL Saturday Helsinki, where I did two sessions. First session was the Power BI cheat sheet explained, and second Storytelling & interactive r…

June 11-12 are getting near, and it is this time of the year to start getting excited. Microsoft Business Applications Summit is getting close. Do you plan to attend it? I will be glad to meet you in person in one of my sessions that will focus on my Power Query book and the development …

Which feature should you use to transform data in Azure Data Factory? Find your answer by comparing Mapping and Wrangling Data Flows :)

This is customized toggle component using only 2 button controls. This has 6 custom properties, 4 input and 2 output : Input TrueText : Text when

A new feature for monitoring the On-premises data gateway was made available for public preview in last week’s release of the May 2019 update. Per the blog post announcement, this feature is …

Common Data Service polymorphic lookups are now available from canvas apps. You can now: Access, set, and filter on the Owner field of any record. Access and set the Company Name field (a Customer data type) of the Contacts entity. Access and set the Regarding field of activity entities such as Faxes, Phone Calls, Email Messages, … Continue reading “Owner, Customer, and Regarding for canvas apps”

The Power Platform User Groups (Power BI, PowerApps, and Flow) are excited to announce that they have added another stop to the Power Platform World Tour – They are headed to beautiful Vienna…

We are very pleased to announce our latest standards whitepaper – PowerApps canvas app accessibility guidelines! Why did we write this white paper? PowerApps embodies the idea of “democratization of development”—anyone in your organization can quickly and easily create a powerful app and share it broadly. But the app maker has an ethical, and sometimes legal, obligation to support “democratization of usage” … Continue reading “PowerApps Canvas App Accessibility Guidelines”

One of the things we care most about on the PowerApps team is delivering reliable and performant experiences. We know that it doesn’t matter how easy-to-use or powerful a product is if it isn’t speedy and bug free. In order to drive the performance our customers have grown to expect, we’ve invested in a new … Continue reading “The PowerApps portal is now faster to load”

Flows make it easy to automate workflows that request approvals and act on responses to them. Currently, flow runs time-out after 30 days, causing any pending steps (like approvals) to time-out as well. While this isn’t a problem for most approvals, there are cases where responding to an approval ca...

Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after the initial success, plans are made to sustain and grow the project.

A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.

The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.

While creating apps using the Common Data Service, makers select an entity as the data source and bind it with data controls. This allows them to add fields in the selected data source to a gallery, data table, or form. This is good for fields that are already present in the data source. However, if … Continue reading “Add new fields while creating your canvas app”

Once again the team had incredibly busy month releasing over 13 new features or enhancements for making your application creation experience even more productive and fun. If you don’t want to wait for this blog post you can always can view a roll up of the upcoming features here: http://aka.ms/businessappsreleasenotes and more fine grained PowerApps … Continue reading “April 2019 updates for Microsoft PowerApps”

PRODUCTS / COMPONENTS INVOLVED Microsoft Power BI Microsoft Office 365 - Audit Logs PowerShell PROBLEM SCENARIO DESCRIPTION / GOAL The goal here, is to look for a remote way that one can export the Office 365 Audit Log with a focus on Power BI for a given data range. RESOLUTION ( SCRIPT ) The ...

Adam walks through column profiling within the Power BI Desktop. This includes the latest updates with the general availability (GA) within the April 2019 Power BI Desktop release. Demo files: https://guyinacu.be/demofiles

I am happy to announce the release of a new version of the Power BI free template app Custom Visuals Exploration Tool. Download it from AppSource here. Do you extensively work with Power BI Custom Visuals? This Power BI Template App connects to Microsoft AppSource to show all the Power BI Custom Visuals which are …

Find out what are the hardware, operating system and software requirements to install .NET Framework 4.5 and later versions.

I have written previously about the use cases of Dataflow in Power BI, and one of them was using one Power Query table in multiple Power BI reports. However, I that article just covered the surface, a…