Power BI

CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demistify pros and cons of each file type!

Deneb-Vega data visualization examples - Power of Business IntelligencePower of Business IntelligenceBlog by Andrzej Leszkiewicz. Excel VBA and Power BI developer and consultant.Andrzej …

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 used similar functions in the past (pre Power …

PyTabular What is it? Getting StartedWhat is it?PyTabular is a python package that allows for programmatic execution on your tabular models! This is possible thanks to Pythonnet and Microsoft's .Net …

Power BI Virtual Network Gateway helps to connect from Microsoft Cloud services to your Azure data services within a VNet without the need of an on-premises data gateway. The VNet data gateway securely communicates with the data source, executes queries, and transmits results back to the service. The

Power BI is a powerful BI tool with a strong “back-office” (ETL, data modeling, DAX), but its “front office” (data visualization – what end users … Read More

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

This blog post will show you how to create a new environment where you can explore and play with Power Pages lots more in Power Platform than beyond.

Microsoft and the Project Management Institute (PMI) are partnering to announce the Microsoft Power Platform University Hub. The University Hub teaches students how to solve a wide range of business problems with low-code—one of the fastest growing technologies in the job landscape today.

Welcome to the Power Apps monthly feature update! We will use this blog to share a summary of product, community, and learning updates from throughout the month so you can access it in one easy place. A variety of new and highly anticipated features are now available which we are very excited to share. We…

Dynamics 365 Sales Report Templates/Examples for Power BI I've released a set of free to use, open-source, Power BI reports for Dynamics 365 Sales. They are built to demonstrate using Power BI for Dynamics 365 Sales and help you jumpstart your own reports and data modeling for Power BI with Datavers

Welcome to the November 2022 update! This month we introduce an Optimize ribbon which makes your report creation experience more streamlined, especially if you are working in DirectQuery mode. Also new this month are Linked Metrics and a new EvaluateAndLog DAX function that enable you to log intermediate values of your DAX expressions. There is more to explore, so please read on!

What are Dataflows and how they fit into the big Power BI data modeling picture? This article will demistify everything about the Power BI dataflows!

Here is the November release of the on-premises data gateway!

Today, most companies are still struggling to become more data-driven. Even though data is inseparably connected with change, there's very little focus on change management. This article examines the three main sources of resistance to data and shares five tips for leading data-driven change.

Power up your knowledge and connections at the European Power Platform Conference! The 2nd European Power Platform Conference (EPPC) will take place ...

As part of a broad digitization strategy, Rabobank adopted Power Platform to streamline internal processes. Rabobank currently uses more than 2,500 Power Apps and Power Automate solutions, including solutions that reduced processing time from three weeks to three minutes.

I'll show you how Power Apps can send email including file attachments, rich text formatting, embedded images, HTML tables, web links & more

Power Apps drag and drop functionality is now available. We can use it to group, re-order and move objects in a gallery-like container.

Recently I had a project where I needed to display a room calendar in Power Apps. I explored a few ways of doing this, and in this post I’m going to show you how to do it using Power Apps, Power Automate, an Azure App Registration and the Graph API! A bit of configuration before we start some dev…

Step-by-step guide! Thrive to enhance user experience by adding any of the three different visual user guides to the Power BI report.

A checklist to ensure your Power BI App is structured, secure, well-designed and helps users find what they need to use your Power BI reports.

Something cool has just been announced for Azure SQL DB: the ability to call a limited number of REST APIs direct from TSQL. The announcement is here: There are code samples here: And guess what, t…

Power BI can handle large data volumes, but just how much data can you load into Power BI? Can Power BI handle big data? How big is “big” anyway? These are questions you may have when y…

One of the most popular topics I’ve ever written about here is the dataset refresh errors you get with dynamic data sources and the Web.Contents function in Power BI (see here and here for ex…

Power BI is architected to consume data in a dimensional model, with narrow fact tables and related dimensions. Introducing a big, wide table in a tabular model is extremely inefficient. It takes u…

Table partitioning has long been an important task in semantic model design using SQL Server Analysis Services. Since SSAS Tabular and Power BI models are built on top of the SSAS architecture, the…

When planning a Power BI solution, how can we plan for scale and growth? Like any technology, Power BI has limits but Power BI can manage a surprising large value of analytic data. We also have too…

The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release.  This feature should be considered essential to anyone who is regularly working in the Power BI space.    In this article I recommend my top five External Tools, that I [...]Read More »