service

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”

Licensing has direct impact on the value of dataflows in Power BI for your organization Dataflows in Power BI sound great – and they are – but who truly benefits from this new element in the BI pro…

Earlier today someone from one of the largest companies in the world asked "Is there any script for counting reports and dashboards in each workspace for the entire (premium) capacity?" The answer is …

As discussed in our blog post announcing support for Azure Analysis Services, we promised to unlock the critical capability of allowing Paginated Reports to be built on the same enterprise semantic…

By using the Power BI management cmdlets, you can automate typical user and administration tasks with significantly less effort and complexity than with direct Power BI REST API calls. To illustrate this point, let’s take a look at Sirui’s original copyWorkspace.ps1 script, published in 2017 for the “Duplicate workspaces using the Power BI REST APIs: … Continue reading “Duplicating workspaces by using Power BI cmdlets”

In a comment to the recent announcement of Workspace Management in the Admin Portal, JohnR asked for an option to export the list of workspaces with the fields provided. This would help facilitate admin work across thousands of workspaces. A great suggestion! Perhaps you wanted to export the list of workspaces placed on Premium capacities, … Continue reading “Exporting the workspaces list from the Admin Portal”

I have just modified from the PBIX file which I have seen in community and existing one has some off, so I have modified and publishing here. eyJrIjoiMTMwOTIwODEtYTdlMy00NGY4LThmYjYtNjM3MmJkZDAwMjcwIiwidCI6IjFkNTM2MDg1LTUzNmUtNGFmNS05NDliLTkxYzc0ODFiYjZhMyIsImMiOjF9

In some of my old posts, which are most popular ones, I explained how to Export data Power BI Desktop or Power BI Service data to different destinations like CSV, Excel and SQL Server. In this quick tip I explain a very easy way to export the model data as a whole to either CSV … Continue reading Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One Shot with DAX Studio

With the recent announcement around E-Mail Subscription support for Paginated Reports in Power BI, you can now have full PDF’s of those reports sent to your inbox on a regular basis. This has…

In response to last week's post regarding the retrieval of the artifacts (reports, dashboards, datasets) within a premium capacity via the Power BI PowerShell cmdlets, a follow up question from a read…

Video by: Reid Havens Learn about the form and function of the new Power BI workspaces , their release management cycles, and how to deploy these workspaces to users outside of your organization.

This blog post details how dataset memory can affect the performance of Power BI reports being consumed in Power BI Premium

For the fifth week in a row, we’re pleased to announce two new features on “New Feature Friday” for Paginated Reports in Power BI. We’ve added support for two new data sources, Oracle and Teradata, and also added the ability to schedule your e-mail subscriptions on an hourly basis. Oracle and Teradata Now Supported We … Continue reading “Oracle and Teradata data source support and hourly e-mail subscriptions for Paginated Reports now available”

The following post describes ten ideas that I believe would benefit Power BI in addressing common and impactful scenarios, particularly from an enterprise BI and IT administration perspective. Each…

I hear this ask quite a bit these days – I want to be able to create e-mail subscriptions with PDF (or other file format) attachments of my full Power BI report or dashboard. Well, you can ac…