Příspěvky se značkou: power bi

What’s new for SQL Server 2019 Analysis Services RC1

We are excited to announce RC1 of SQL Server 2019 Analysis Services (SSAS 2019). The SSAS 2019 release is now feature complete! We may still make performance improvements for the RTM release. RC1 introduces the following features: Custom ordering of calculation items in calculation groups Query interleaving with short query bias for high concurrency workloads Online attach for optimized synchronization of read-only replicas SuperDAXMD for improved performance of Power BI reports over SSAS multidimensional Governance setting to control Power BI cache refreshes

» Další informace

Introducing the new look for Power BI Service

We’re excited to announce a public preview of the ‘new look’ for Power BI service. We’re refreshing the user interface to provide a modern experience that’s simpler and builds on customers’ familiarity with Microsoft products. Simplified action bar, vertical navigation, metadata – read on to learn more about how we’re simplifying navigation and making Power BI easier to use and accessible to many more.

» Další informace

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!

» Další informace