As a Power BI service admin, do you frequently need to list all workspaces in your tenant, and all reports, dashboards, and datasets in those workspaces as well? If the answer is yes, you probably had to build your solution such that in a first call, all workspaces had to be retrieved by using the GetGroupsAsAdmin API or the Get-PowerBIWorkspace cmdlet. It was then necessary to loop through the result set to make additional calls to get the reports, datasets and dashboards within each workspace by using the GetReportsInGroupAsAdmin, GetDashboardsInGroupAsAdmin, GetDatasetsInGroupAsAdmin APIs or the Get-PowerBIReport, Get-PowerIBDashboard, and Get-PowerBIDataset cmdlets respectively. Unfortunately, this approach is slow and inefficient. In a large Power BI environment, it is even impractical. There must be a better and more efficient way! The secret to avoiding these expensive loops is in the OData Expand Query Option ($expand)—and I am proud to announce the recent release of support for $expand in the GetGroupsAsAdmin API!
» Read more As we kick off the Microsoft Business Application Summit with our amazing community at Atlanta, I wanted to share some exciting Power BI news as part of the event, including the June release of Power BI Desktop and the general availability of Paginated Reports in the service.
» Read more Template app general availability announcement and latest features
» Read more We’re almost halfway through the year and what a great start it’s been to 2019! The Power BI team continued to deliver some of the most anticipated features in the month of May. We were also heads down planning for the Microsoft Business Applications Summit, where we look forward to connecting with many of you there next week!
» Read more This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals.
» Read more This is the first blog post dedicated to Analysis Services on the Power BI blog. As discussed in this post on the old Analysis Services team blog, Microsoft is moving off MSDN and TechNet blogs. We have made it clear that Power BI will be a one-stop shop for both enterprise and self-service BI on …
» Read more Dozens of Power BI visuals come out-of-the box with Power BI Desktop. These visuals are available in the visualizations’ pane when you create or edit Power BI content. These visuals are just the beginning of the available options to help you tell your data story. Learn about the variety of options you get with Power BI visuals and how to manage them in your organization.
» Read more We’re happy to announce one of our most commonly requested features for custom connector support in Power BI – Trusted Third Party Connectors. As it stands today, the only way that you can use a connector with the ‘Recommended’ security setting is for it to be signed and distributed by Microsoft. Unfortunately, this stops a … Continue reading “Trusted Third Party Connectors for Power BI”
» Read more 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”
» Read more 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”
» Read more