Posts tagged: power bi

Avoiding workspace loops by expanding navigation properties in the GetGroupsAsAdmin API

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

Announcing Paginated Reports in Power BI general availability

Based on the technology used in SQL Server Reporting Services, Paginated Reports brings a new set of enterprise reporting capabilities to the Power BI service. It enables developers and BI professionals to create and distribute highly formatted, pixel-perfect reports right alongside their interactive Power BI content, becoming the first cloud BI solution that combines the power of self-service BI with the needs and capabilities of traditional Enterprise BI scenarios.

» Read more

Report Parameter Support for Paginated Report E-Mail Subscriptions are Now Available

The Paginated Reports team closes out May with another “New Feature Friday” blog post announcing one of the biggest enhancements to e-mail subscriptions in Power BI to date. With today’s update, Paginated Reports users can set up an e-mail subscription for themselves and their colleagues and choose the parameter values they wish to use for …

» Read more

Enhanced Attachment Support for Paginated Reports E-Mail Subscriptions is Now Available

“New Feature Friday” returns for the latest feature update for Paginated Reports. We’ve just rolled out support for five new attachment options for your e-mail subscriptions in Power BI. In addition to PDF, you can now choose one of the following new attachment types for your subscription(s) – PowerPoint presentation (PPTX) Excel Workbook (XLSX) Word …

» Read more