Ruki's Blog

In today’s post, we will discuss how to get metadata for a requested list of Workspaces using the Power BI Scanner API. The result shows Data sources and connection details for each Workspace, Data sources used by each Dataset, and Reports connected to each Dataset. For the Datasets, you can also extract metadata like tables, columns, measures, DAX expressions, mashup queries, and so on. To accomplish this, we will use 4 Scanner APIs: The user must be an administrator to…

Read More Read More

Manage gateway installers On Power BI service Gateway management or Power platform Admin center, a Global admin or a Power BI service admin can use Manage gateway installers to manage who can install an on-premises data gateway in a tenant. This feature does not apply to personal gateways. A Power BI idea for approval process before gateway becomes active has been completed. However, to restrict or prevent users from installing personal gateways in a Power BI tenant, you need to…

Read More Read More

In today’s post, we will discuss how to automate exporting Power BI Workspaces, Datasets, Reports and Dashboards using PowerShell. Step one: To use PowerShell cmdlets for managing and interacting with Power BI, you first need to install the module: MicrosoftPowerBIMgmt Install-Module -Name MicrosoftPowerBIMgmt Step two: Sign in to Power BI using below command, a prompt will pop up to authenticate to Power BI. For this example, I am authenticating as Power BI Admin. Connect-PowerBIServiceAccount Note: You can also authenticate using…

Read More Read More