Power BI

Excel’s new Automate tab allows you to tackle your automation needs quickly using Power Automate. All from within the same tab, you can build Office Scripts and enhance their capabilities using Power Automate. For example, you can connect your Office Script to one of Power Automate’s 800+ connectors like Outlook to send daily emails summarizing changes made to your workbook. Get creative, the automation possibilities are endless!

Power Apps can look amazing if you have a strong understanding of design principles & UI UX skills. Try these 5 Power Apps design tips.

Learn to solve the dynamic data sources error with OData.Feed in Power BI by relying on query folding

Back around 2015, Microsoft introduced the current Power BI platform to replace its "Power BI for Office 365" SharePoint/Excel-based offering that most people have long forgotten, with a focus of offering a self-service experience to business users. This product became so successful that a few years later Power BI Premium was positioned as "a superset

Contribute to phanguyenx/vega-lite development by creating an account on GitHub.

This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API.

We look at how Tabular Editor shortcuts can revolutionize your productivity, linking them to macros, common actions and more.

This short article explains how to quickly count measures (or any model object) in Tabular Editor. A C# script is provided to count all model objects as a quick pop-up.

Reading Time: 2 minutes A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon chart and Slopegraph in Power BI without the use of...

A complete solution to extract the Power BI audit log, Power BI tenant metadata and Microsoft Graph data. Using Azure Data Factory or Integration Pipelines in Azure Synapse Analytics - justBlindbae...

Hue, saturation, and brightness, explained · Color variations with hue · Adjusting visibility with saturation · Black vs. white · HSL vs HSB

In the previous articles of the Mastering DP-500 series, we’ve explained what happens when you hit the Publish button in Power BI Desktop. Assuming that you’re not using a Live connection mode, once …

In this post, I share how participating in ‘data communication’ activities like blogging, speaking or making video tutorials can help you learn faster, sharing my own experiences & learnings writing articles in 2022.

Power Apps work great as a standalone tool for replacing your old spreadsheet with a more structured and cloud native data entry solution. However, what if I told you that: Power Apps can be embedded into your Power BI Reports Power Apps can display, and let user interact with, data coming from your

We’ve just published a new minor version of the CLI for Microsoft 365 with new commands for working with and managing Microsoft 365 and SharePoint Framework projects on any platform.

A lot happened in the Microsoft Data Governance area, especially in the area of Microsoft Purview Data Governance. Let’s go back in history and wrap up the announcements that have been made i…

DAX window functions can result in simpler, more efficient SQL when using Power BI DirectQuery mode and a greater likelihood that aggregations are used

Collection of tools and guidance meant to help you extend Microsoft 365 & Power Platform to your needs following best practices. Don't reinvent the wheel and focus on what truly matters for your organization.

In this blog we will learn about What is a Record, Extracting Records from a Table, Creating Records from Scratch. Also, there are two practical Examples of using Records that might be helpful in many different ways!

Get the equivalent of Excels FV function to calculate the future value of a series of payments for Power Query as well.

Get the equivalent of Excels PV function to calculate the present value of a series of payments for Power Query as well.

This is my wishlist of top 10 Power Apps features I'd like to see added. Add your own desired features in the comments section.

The DAX OFFSET function has been talked about for a while now. The main entry point to this function for almost everyone was the article by Marc Lelijveld How to OFFSET in DAX would make your life easier – Data – Marc (data-marc.

There are new DAX functions: INDEX, OFFSET, and WINDOW. These functions allow us to compose powerful filter tables that have not been possible before or at least require very complex DAX code. These functions come with additional clauses, namely ORDERBY and PARTITIONBY. PARTITIONBY enables the partitioning of a virtual table.

Contribute to PBI-David/Deneb-Showcase development by creating an account on GitHub.

Shared via Flipboard