Power BI

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…

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”

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…

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…

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…

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

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 …

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

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”

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…

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 …

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.

Now that tax season is over, are you ready to see how your contributions are helping the government run? As it did in 2017 and 2018, USAFacts published a 10-K Report using Microsoft Power BI to show a comprehensive view of US federal, state and local governments’ revenues and expenditures. The not-for-profit, non-partisan institute—funded by former Microsoft … Continue reading “Through Power BI, USAFacts Explores Government Financial Data In Latest Report”

One of the primary reasons people go to conferences is to meet the presenters. At the Microsoft Business Applications Summit and the Microsoft presenters we have an entire “Ask the Experts” experience to make this easy. For community presenters we have created a community lounge and will be schedu...

Microsoft Business Applications Summit June 10 – 11 in Atlanta, Georgia is almost here and you have one more reason to attend year…A chance to meet the community super stars. We know, one of the pr…

An exploration of embedding files in a Power BI dataset, I got the idea when I was doing some reading about Power BI, stumbled upon an artice about embedding images at this link: https://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html which made me think about coupling files, or ...