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!
» Läs mer 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
» Läs mer 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.
» Läs mer 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.
» Läs mer 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.
» Läs mer 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.
» Läs mer Bring Your Own Key (BYOK) preview available
» Läs mer Take this short survey to influence our plans for AI in Power BI
» Läs mer 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.
» Läs mer Take our quarterly survey to help us continue to improve Power BI.
» Läs mer