Power BI

I was shocked, suddenly important reports were missing from my workspace in Power BI service. But thanks to the help of Mellisa Coates, I was able to make

Download the cheatsheet that will help you fine tune your Power BI reports!

A while back, I was working on a project involving getting data from Excel files. The Excel files contain the data in sheets and tables. Getting the data from the tables is easy. However, the data in the sheets have some commentaries on top of the sheet, then the column names and then the data … Continue reading Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online

Synapse Analytics allows the creation of External Tables and Views within a Serverless SQL Pools database and also a Spark database. These objects can be shared between Spark and Serverless using shared metadata. An example is an External Table created using a Spark Pool that can be queried by using a Serverless SQL Pool. During...

Collaborate seamlessly with your colleagues with multi-player apps, on-line statuses and easy sharing.

Here is a fun way to use Q&A functionality to build a data dictionary in Power BI and add GIF animation to the report page background.

While you're validating your idea, there is no need to spend a fortune commissioning a decent-looking logo. We have created a library of free logos which you can use as placeholders for your projects.

I first wrote on this topic way back in March 2019. I love Power BI, and it is one of the most affordable BI products on the market for most companies. If you are a small company of 10 or 20 people, it is dirt cheap at $10 per user [...]Read More »

Excel is the most frequently used tool for storing and working with the world's data. We are amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the grid and formulas to capture, analyze, and collaborate on data.     Until recen...

English

When Microsoft introduced Azure for the Microsoft public, it was a new way of thinking. We were suddenly paying for what we needed and when we needed it. Amazon had been there for a long while, but…

Web API operations in portals so far were limited to creating, updating, deleting, associating and disassociating tables. With this public preview, we’re adding the capability to retrieve data using GET requests through portals Web API

The Microsoft Ignite Book of News is your guide to key news items that we are announcing at Microsoft Ignite.

Dataverse security concepts – Modernize Business Units

As it is Microsoft Ignite week, new features are being added to all products. This post is all about comments in Power Automate

I know that I personally have been interested in what makes up a PBIX file and in this blog post below I will explain from my understanding what are the different parts that make up the PBIX file. It is rather interesting in that it is actually made up of a few different aspects. How to view the contents of...

One of the many benefits of Power BI is the possibility to create your own theme file, which defines many design properties of a report…

Optimize your images and convert them to base64 online. Drag & Drop your files, copy to clipboard with a click and use the result in HTML and CSS.

Summary of planned features for Power BI.

"It's M365 Below in Chicago!", an On The Spot Network event, needs you to share your expertise with other professionals that work with Microsoft 365 and Power Platform across the world!The next M365 …

Today we are announcing the Public Preview for the new Microsoft Access connector for the Power Platform. The new connector to Dataverse and the Power Platform enables new scenarios and unlocks further benefits for MS Access developers who can now create custom apps, automations, and chatbots built with Power Platform that work directly with their Access data and Dataverse and Dataverse for Teams,

Today, at Microsoft Ignite, we are announcing the latest step in helping organizations harness the power of low-code automation with several updates in Microsoft Power Automate.

Provides guidance on how to automate document processing in AI Builder.

This topic provides information on how extract tables from an invoice, and tables that span fewer or greater than two pages, in AI Builder.

Check out the new enhancements to AI Builder we announced at Microsoft Ignite to help bring AI into your Power Platform solutions.

At Ignite, we announced the next evolution in helping organizations streamline how they work with the preview of process mining via process advisor in Microsoft Power Automate.  

As a developer, how many times have you had a need to test different Microsoft 365 APIs? For me, this is a fairly frequent task. Most often it's SharePoint REST API or MS Graph. Every time you should think about the authentication part because all of... [Click to read more]