Power BI

Have you tried creating a virtual table and found it too difficult? Do you wish you had an easy way to integrate external data from SharePoint and SQL into Dataverse? We are excited to announce that makers can now create virtual tables directly in the maker portal in just a few minutes using a guided…

We’ve just released support for implementing native query support in your own Power Query custom connectors through the use of the Power Query SDK. This new support allows Power Query connector developers to implement support in their connectors to enter a native query that can run against their data sources through the use of the […]

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

Securely deliver interactive data exhibits using Publish Interactive’s seamless integration with leading data visualisation tool, 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

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

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...

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.

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.

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

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.

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.

Microsoft Graph toolkit is amazing, but unfortunately not available for Power Apps - Let's fix that!

I started my Power Apps blog in June 2020 with no expectations. All I wanted was a place where I could write about the cool things and to document best practices.

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

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.