Multiple data source definitions on the On-premises data gateway for the same data source
This blog talks about the recently enabled feature “Multiple data source definitions to the same data source”
This blog talks about the recently enabled feature “Multiple data source definitions to the same data source”
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.
To kick off July, we’ve dropped the latest update to Power BI Report Builder in the download center. It includes, for the first time, the ability to browse your Power BI workspaces and connect to your Power BI datasets, whether or not they are backed by premium capacity.
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!
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