Microsoft Power BI 博客

Power BI 2024 Holiday recap

Season’s greetings, Power BI Community! As we wrap up an incredible year, the Microsoft Power BI team is taking a break for December. All planned updates will roll out in January including the next Power BI Desktop release. As we approach another year of innovation, let us take a moment to reflect on some key highlights from 2024.

阅读更多内容

最新文章

Unlock Petabyte-Scale Data Sets in Power BI with Aggregations – Upcoming General Availability!

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.

» 阅读更多内容

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!

» 阅读更多内容

Introducing dataflow templates; A quick and efficient way to build your sales leaderboard and get visibility over your sales pipeline

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.

» 阅读更多内容