The 4th part of the blog series covers what happens when Row Level Security is applied to a Power BI Premium report and if there is any effect.

Using Power BI is simple, however, using it properly, needs a good architecture. In a multi-developer tenant, the architecture of a Power BI implementation should allow multiple developers to work on …

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup137 2 Minute Tuesday: https://guyinacu.be/multiselecttitles Patrick’s tech video: https://guyinacu…

April was packed full of new capabilities for Power BI. Thank you for the ongoing support and feedback – we couldn’t have done it without you. Here’s a quick rundown of everything we announced last month: Power BI dataflows GA Q&A update for dashboards New workspaces experience GA Paginated Report Builder New Power BI regions … Continue reading “Power BI Service and Mobile April 2019 feature summary”

Which feature should you use to transform data in Azure Data Factory? Find your answer by comparing Mapping and Wrangling Data Flows :)

A new feature for monitoring the On-premises data gateway was made available for public preview in last week’s release of the May 2019 update. Per the blog post announcement, this feature is …

Find out what are the hardware, operating system and software requirements to install .NET Framework 4.5 and later versions.

I have written previously about the use cases of Dataflow in Power BI, and one of them was using one Power Query table in multiple Power BI reports. However, I that article just covered the surface, a…

We are happy to announce that we have just released the May update for the On-premises data gateway (version 3000.5.185). Here are some of the things that we would like to highlight with this month…

Last week I delivered two online sessions on the topic of integrating Power BI dataflows with an organizational Azure Data Lake Storage Gen2 storage account. I’ve blogged on this topic before…

Back in September of last year, we announced dashboard commenting in Power BI. Since then, we’ve seen thousands of you leverage this feature to collaborate with colleagues and start discussions within your organization. Today, I’m excited to announce that we are bringing the same commenting capability to Power BI reports! With report commenting, you can … Continue reading “Announcing Report Commenting for Power BI Service and Mobile”

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…

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…

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”

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

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.

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…

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 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

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 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”

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”

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…

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 …

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…

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”

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…

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”

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