Power BI

This article explains the setup instructions to work with the Service tab of Power BI Helper. Download Power BI Helper from here. Power BI Helper is a third party application, and any third party appl…

Watching an interesting video on data science trends by a Google data scientist who recommended this data set as good practice, I recorded a video that documents my process working on it from start to…

Patrick takes a quick look at Power BI Report Builder including how to get it. This report builder is optimized for the Power BI service. Patrick calls out a few reasons this is the case. Power BI Pag…

This post is a beginning to a series of articles about building analytical capabilities in Azure using data lake, Databricks and Power BI. On the surface, those technologies seem like they were specif…

The new Power BI App Workspace experience GA’d in April of 2019. Adam takes you through what the new Power BI App Workspace is all about and what is coming down the road.

In Power BI datasets that combine data from multiple data sources in a single M query, privacy levels define a how the data sources are isolated from each other. Restrictive isolation levels block data from being exchanged with other data sources, which can reduce functionality and impact performance but ensures that sensitive data does not … Continue reading “Privacy Levels for Cloud Data Sources”

With Power BI apps, you can create collections of dashboards and reports and publish these apps to your whole organization or to specific people or groups. For the second post in our series we’re c…

Power BI Live Connect reports allow the dataset to be stored in Azure Analysis Services (Azure AS) or SQL Server Analysis Services (SSAS) while the report itself resides in the Power BI service. Re…

This is the first in a blog series on Power BI Premium Performance and how to see how much memory is being used in Power BI Premium

This is the third article in my series about how to make Power BI Premium more affordable for small to medium sized enterprises (SMEs). In my first article I explained the problem and the logic be…

Getting “Failed to load data model” for an Azure Databricks DirectQuery connection in Power BI? Adam hit it too and walks through how to fix it in Power BI Desktop using Power Query.

If you're a Power BI Administrator, and particularly if you're responsible for administering a large and varied Power BI environment, you may consider investing time into the development of a Power BI…

Does it take a long time to get your data refreshed in your Power BI model? Should you wait for hours for the refresh to finish because you have complex transformations behind the scene? Does the long…

The full credit for this goes to the Guy in the Cube for his video where Adam talks about how to fix direct query to Azure Databricks models deployed to PowerBI.com . Unfortunately, this issue also af…

Here is another weeks Power BI RoundUp, and there is still a lot going on! Paginated Reports in Power BI Apps As you can see above paginated reports are now available when you create an app for your o…

After the Azure Analysis Services web designer was discontinued per march 1 2019 – link – there is no official tool to do a move of a PBIX datamodel to Azure Analysis Service. But by using a few diffe…

Easy way to get Teams data (or other data from the Graph API) into Power BI without using a custom connector but Microsoft Flow instead.

E-mail subscriptions is one of the key features used by millions of SQL Server Reporting Services customers today. Our latest release for “New Feature Friday” is the support of Paginated Reports in…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick’s tech video: https://guyinacu.be/modelview Adam’s tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing values for the total (@FerrariAlberto) Power Query Memory Usage, Dataflow Container Size And Refresh Performance (@cwebb_bi) Creating a Fiscal Saturday Calendar (@kpuls) Governance settings for Power […]

We have rolled out a new high-level summary metrics experience in the Power BI Admin Portal . This new experience replaces the four summary tiles you previously saw : CPU, Memory thrashing, Memory …

SSRS is near and dear to my heart. My first book (“Microsoft Reporting Services in Action” published in 2004 by Manning) was on this subject and I became an MVP because of my contributions around SSRS…

Today we are pleased to announce Query Caching for Power BI Premium, which speeds up content loading by caching previously-used query results. The setting is applied at the dataset level so any rep…

We launched the public preview of the Data Gateway administration feature on the Power platform admin center in January. This feature provides tenant admins with visibility into all On-premises dat…

The second part of the series shows how to look and optimize your Power BI model so that it can be smaller and used inside Power BI Premium

Power BI real-time streaming is the perfect solution for IoT. Whether processing data through Azure Stream Analytics, the PubNub data stream network, or a custom Internet of Things solution, Power BI …

In Power BI, today, a new data source (cloud or on-prem) is created only if a successful connection can be made to the data source with the credentials provided. If it fails, the data source creation fails with an error message as shown below: The same applies to editing credentials for existing data sources. If … Continue reading “Skip Test Connection for On-premises and Cloud Data Sources”

In this post I explain what XMLA endpoints mean for Power BI and how you can create a test environment and connect from SSMS, Excel etc... to Power BI Premium

We are happy to announce that we have just released the April update for the On-premises data gateway (version 3000.3.138). Here are some of the things that we would like to highlight with this month’s release: Availability of the following connectors via the On-premises data gateway Oracle Essbase connector PDF support in File connectors. The … Continue reading “On-premises data gateway April 2019 update is now available”

One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web…

As organizations grow their Power BI deployments and foster a data culture, users will have an ever-increasing amount of data available to them. This wealth of information makes it critical to have tools to find and organize relevant content. Last September, we took the first step in improving our overall navigation experience by introducing a … Continue reading “Announcing Power BI Home General Availability (GA) & Roadmap”