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”

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 …

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

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…

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…

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…

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 …

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 […]

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…

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.

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…

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…

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…

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…

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…

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.

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…

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

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…

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…

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”

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.

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…

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…

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…

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…

It’s time again to recap all the features and announcements we made in the month of March. Premium Multi-Geo General Availability Users outside your organization can edit and manage content with Az…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup132a 2 Minute Tuesday: https://guyinacu.be/sortmonth Patrick’s tech video: https://guyinacu.be/geoflow Adam’s tech video: https://guyinacu.be/playgroundtoken Sources The easiest way to do small-multiples in Power BI! (@TumbleRoad) Power BI Paginated Report Builder Now Available Announcing Power BI dataflows general availability Creating Machine Learning models in Power […]

In this tutorial you use Cognitive Services and dataflows in Power BI.