Power BI REST API URL as source in Power BI

[abpgupta]

Hi All

Is it possible to get details of workspaces, datasets and reports using Power BI Rest API as source? When trying one of rest API URL, it asks for sign in information.  Can you please guide here?

Thanks a lot!

[v-henryk-mstf]

Hi @abpgupta ,

According to your description, to get detailed information about workspaces, datasets, etc., it is more convenient to use powershell.
Steps:

Install the corresponding module.

Install-Module -Name MicrosoftPowerBIMgmt

Log in to the account corresponding to the powerbi service, only if the identity verification is successful can you get the information about workspaces, datasets, etc. in the organization successfully

Connect-PowerBIServiceAccount

Enter the relevant code to get the information

Get-PowerBIWorkspace -All
Get-PowerBIDataset

For more details, you can related document link.

Power BI Cmdlets reference | Microsoft Docs

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abpgupta]

Thanks @v-henryk-mstf  for information! I am looking to use Power BI only to get data and visualize information. The option Get Data - Web to use Rest API URLs and collect information is not working for me so not sure if it is not possible or it is my access issue. If it's possible, could you provide one sample on having such connection? 

[amitchandak]

@abpgupta , You should be able to log in using your Power bi service login. Please check for any other setup and auth requirement.