Here you will find Power BI resources – for example, news from Microsoft blog and various mix of information from TOP blogs and magazines focused on Power BI.
- Microsoft Power BI Blog | feed – the latest information and news about Power BI directly from Microsoft
- Excelerator | feed – high quality source of information and tutorials about Power BI
- Kasper On BI | feed – Blog by Kasper de Jonge – Power BI program manager
- Blog Chrise Webba | feed – Chris blogs for over 10 years and has over 1,000 articles focused on Power BI and DAX on his website
- Prathy | feed – Blog by Pratha Kamasani – Independent contractor from India living in London
- Datachant | feed – Blog by Gil Raviv, which helps clients (including Fortune 500 clients) create modern self-service BI solutions.
Disclaimer: Websites in the list are listed here as high quality sources of information. You can ask me to add your favorite website and i will consider the request. A website may be delisted after revision or at the request of the webmaster…. Contact Me »
- Announcing general availability of service principal profiles in Power BI Embeddedon 20. 3. 2022 at 23:46
I’m happy to announce a new method that allows a much larger number of customer tenants per one service principal by introducing a service principal “child” named service principal profile. Each service principal profile can administer a customer tenant, and the number of profiles per service principal can reach hundreds of thousands.
- New Options For The Table.Buffer Function In Power Queryby Chris Webb on 20. 3. 2022 at 19:28
The March 2022 release of Power BI Desktop includes some new options for the Table.Buffer M function that can be set in a new second parameter. The options are of type BufferMode.Type; if you look at the built-in documentation for this type you’ll see the following: The two allowed values are: BufferMode.Eager: The entire value
- Power BI March 2022 Feature Summaryon 17. 3. 2022 at 9:06
Welcome to the March 2022 update. We are happy to announce a couple new features this month! How about error bars for line charts and dynamic format strings support for all chart elements? Also, we have some updates to the Azure Maps visual and Sensitivity labels, datasets hub and Power BI Goals. There is more to explore, please read on.
- The ExtAuth Trace Event In Power BIby Chris Webb on 13. 3. 2022 at 21:16
When you’re looking at the Log Analytics data for your Power BI Premium dataset, or studying a Profiler trace, you may see a command called ExtAuth in the OperationDetailName column: It is documented here as “An internal service-generated command to perform authentication” – and as such it’s not something you have any control over. It
- Dataset backup and restore performance just got a lot betteron 7. 3. 2022 at 13:01
Today, we’re happy to announce significant performance improvements to backup and restore operations for datasets in Power BI. Our benchmark tests with 1GB, 5GB, and 10GB datasets show backups can now be completed up to 22 times faster than before, and the time required for restore operations can also be reduced by more than 30%.
- Why Not All SQL Queries Can Be Used As A Source In Power BI DirectQuery Modeby Chris Webb on 6. 3. 2022 at 14:43
A few days ago I was tagged on a thread on Twitter: my old pal Mim was upset to find that he couldn’t use a SQL query with a Common Table Expression as the source of a table in DirectQuery mode. He worked out why without my help but I thought that it was worth
- Real Life Power BI Demo – What Size Water Tank Do I Need?by Matt Allington on 1. 3. 2022 at 22:34
I always tell people in my training classes that the best way to become good at using Power BI is to get plenty of practice. Best case scenario, you would do something at work that will help you succeed in your job and hence you will get paid to learn. [...]Read More »
- Refreshing Excel Power Query Queries With VBA And Power Automate For Desktopby Chris Webb on 27. 2. 2022 at 20:39
At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are available now for everyone using the Insiders build of Excel. Not particularly interesting on its own (I wrote a post a few
- Deep Dive into InfoRiver Export to Excelby Matt Allington on 22. 2. 2022 at 19:55
This is a further article in my series where I share with you what I have learnt about the InfoRiver custom visual. As good as Power BI is, it will take Microsoft many more years to make it fully featured. Microsoft Excel is 37 years old, and I can assure [...]Read More »
- On-premises data gateway February 2022 update is now availableon 22. 2. 2022 at 13:59
On-premises data gateway (standard and personal mode) release for February 2022
- TSQL Table-Valued Functions And Dynamic M Parameters In Power BI DirectQueryby Chris Webb on 20. 2. 2022 at 14:00
My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure SQL DB and Synapse) with dynamic M parameters. In my opinion dynamic M parameters are extremely important for anyone planning to use DirectQuery: they give
- Power BI February 2022 Feature Summaryon 17. 2. 2022 at 10:29
Welcome to the February 2022 update. We are thrilled to announce a variety of new and highly anticipated features such as new mobile formatting options, Dynamic M Query Parameters support for more data sources, deployment pipeline enhancements and improvements to downloading a PBIX file.
- Create stunning, mobile-optimized Power BI reports with mobile layout’s new visual formatting pane (Preview)on 17. 2. 2022 at 10:20
We are thrilled to announce the public preview of NEW mobile formatting options. Now you can choose to have two separate designs for the same visual, one for each layout.
- Plotting 2 Columns on the Legend of a Chartby Jason Cockington on 17. 2. 2022 at 1:32
At a recent training course, one of the students asked if it was possible to add two different columns on the legend of a line chart, so that when a selection is made on a second slicer the chart splits to reveal multiple lines. Given others in the class showed [...]Read More »
- Speed Up Power BI Refresh By Increasing The Amount Of Memory On Your On-Premises Data Gateway Machineby Chris Webb on 13. 2. 2022 at 14:39
If your Power BI dataset needs to connect to an on-premises data source it will need to connect via an On-Premises Data Gateway; what’s more, if you have a Power Query query that combines data from cloud and on-premises data sources, then Power BI needs to connect to all data sources used (even if they
- Inforiver – No-Code Partner Innovation for End-User Self-Service inside Power BIon 11. 2. 2022 at 9:07
No-Code Partner Innovation for End-User Self-Service inside Power BI
- Introduction to Power BI Dataflowsby Delia Fernandez on 9. 2. 2022 at 2:48
For my first blog post I wanted to write about one of my favorite topics: Power BI Dataflows. If it’s the first time you read about this product or if it’s a product you have been trying to learn more about, this is meant for you. What Are Power BI Dataflows? Power BI Dataflows is The post Introduction to Power BI Dataflows appeared first on […]
- Announcing general availability of Export Power BI report to file APIon 7. 2. 2022 at 8:00
I am thrilled to announce the general availability (GA) of Export Power BI report to file API. This API allows you to export Power BI reports to the following file formats: PDF, PPTX (PowerPoint) and PNG, by using a REST call.
- Expanding Azure Data Explorer Dynamic Columns In Power Queryby Chris Webb on 6. 2. 2022 at 10:46
Azure Data Explorer has a data type called dynamic which can be used to hold scalar values as well as arrays and property bags; you can read about it in the docs here. For example (following on from my recent series on DirectQuery on Log Analytics, starting here) the ApplicationContext column in the PowerBIDatasetsWorkspace table
- Announcing new Admin APIs to retrieve email subscriptions and widely shared reportson 1. 2. 2022 at 9:00
New admin APIs to retrieve email subscriptions and widely shared reports
- Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 4: Query Sessionsby Chris Webb on 30. 1. 2022 at 14:00
In my last post I showed how to use Log Analytics data to analyse Power BI query activity. The problem with looking at a long list of queries, though, is that it can be overwhelming and it can be hard to get a sense of when users were and weren’t actively interacting with a report.
- Reminder: WebView2 will be required for the next Power BI Desktop releaseon 28. 1. 2022 at 9:21
Starting with the next Power BI Desktop release, WebView2 will be required. If you have not switched over yet, please take action now to avoid interruptions.
- Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 3: Queriesby Chris Webb on 23. 1. 2022 at 19:06
In the first part of this series I showed how to create a Power BI DirectQuery dataset connected to Log Analytics to do near real-time monitoring of Analysis Services activity; in the second part I showed how to use this technique to monitor dataset refreshes in a workspace. In this blog post I’ll discuss how
- Getting The IDs Of All Visuals In A Power BI Report Page Using The Power BI Embedded Analytics Playgroundby Chris Webb on 16. 1. 2022 at 9:00
Log Analytics contains information on the dataset, report and visual that are associated with a DAX query but that information is in the form of IDs rather than names. Getting the IDs for specific datasets and reports is fairly straightforward – you can get them from urls in the Power BI Portal – and as
- Using Macros in Tabular Editor 3by Matt Allington on 6. 1. 2022 at 2:24
I have written quite a few articles about Tabular Editor over the last few years. I recently started using Tabular Editor 3, and I absolutely love it. Buying this product is one of the easiest ways you can significantly improve your Power BI Data Modelling productivity. For US$100 per year [...]Read More »