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 We’re two weeks post-GA of Paginated Reports in Power BI, and we wanted let you know about several updates we’ve made since then
» Read more A dataflow template can expedite this process by providing a predefined set of entities and field mappings to enable flow of data from your source to the destination, in the Common Data Model. A dataflow template commoditizes the movement of data which in turn reduces overall burden and cost for a business user.
» Read more We’re excited to announce we’ve started to roll-out the Viewer role for the new workspace experience, perfect for users who need to view content within workspaces without the ability to modify it. Viewer role enforces RLS even for users browsing the workspace, its a replacement for ‘read-only’ classic workspaces.
» Read more We are excited to announce new improvements to Power BI dataflows releasing this month including an enhanced compute engine to drastically improve data refresh times and a new set of dataflow templates to help you easily connect to common data sources mapped against the common data model.
» Read more The Microsoft Business Application Summit is behind us but that doesn’t mean there’s a lot of content we can share with the community. We recorded almost every session on site, and we made them available in our community.
» Read more Bring Your Own Key (BYOK) preview available
» Read more Take this short survey to influence our plans for AI in Power BI
» Read more The conference might be over, but there’s so much more in store! Get ready to transform your business with the latest in Microsoft Business Applications. Explore 200+ sessions, workshops, and keynotes from Microsoft Business Applications Summit, available now in the Power BI Community.
» Read more Take our quarterly survey to help us continue to improve Power BI.
» Read more