Power BI Developer community June & July update
This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals.
This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals.
June was yet another exciting month for Power BI! Read on for a summary of the announcements we made in both the service and mobile.
With Power BI aggregations, organizations can perform petabyte-scale analytics with instant response times, exploring and analyzing trillions of rows of data and interactively extracting insights on the fly. Aggregations can dramatically reduce the cost of unlocking large datasets for decision making.
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!
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.