Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Folks!!
Will it be possible to call Power BI Rest API from either from Power BI Desktop or Power BI Services.
I.e.can we call below REST API from Power BI Desktop or Power BI Services.
Command :
$url="https://api.powerbi.com/v1.0/myorg/groups"
Invoke-PowerBIRestMethod -Url $url -Method Get
Thanks
Amit Srivastava
Thanks
Amit Srivastava
can any one tell, How can I call the api in power bi service ? Pls help
Hi @amsrivas ,
You can use Web connector to connect to Rest API in power bi desktop.
Here is the a viedo and a document that introduce it in details:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yingjl
I want to call below REST API from PowerShell
$url="https://api.powerbi.com/v1.0/myorg/groups"
Invoke-PowerBIRestMethod -Url $url -Method Get
When I putting https://api.powerbi.com/v1.0/myorg/groups on Web Connector, it sat "Access prohibited" but wondering as i can excute this command from PowerShell and able to fetch data.
Could you please suggest why i am getting access related issue while connecting from PowerBI.
Thanks
Amit
Hi @amsrivas ,
Based on my test, this api will return the specific power bi account workspace information as json format in Powershell if you have connecting to your power bi account by "Connect-PowerBIServiceAccount"
We can run this Powershell script to export it as a .csv file:
It will create a .csv file at your specified path which includes the above information:
If you cannot use "Connect-PowerBIServiceAccount" command in powershell, run Powershell as administrator and run this command: "Install-Module -Name MicrosoftPowerBIMgmt"
After getting the .csv file, we can connect it in power bi desktop and power bi service to transform data as your needed.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yingjl ,
Can understand, this can be achieved via steps you have mentioned however issue in this process is i am not able to automatized the process.
I can say, it can automatised via TASK SCHEDULAR or AZURE FUNCTION, but unfortunately, i dont have priviledge to use either of the option.
Is there any other way to automatised this process.
Thanks
Amit
Hi @amsrivas ,
As far as I know, if you dont have priviledge to use TASK SCHEDULAR or AZURE FUNCTION, PowerShell is a better way to achieve this while it could not be automatically.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@amsrivas , Power bi API need token based Auth. Try if his solution can help
also check this
https://docs.microsoft.com/en-us/power-bi/developer/embedded/generate-embed-token
Hi @amitchandak
We do not have priviledge to use AZURE as we do not have Azure account/subscription with us.
Is there any other way via which we can achieve the requirement without having need of Azure.
Please suggest!!
Thanks
Amit
User | Count |
---|---|
134 | |
74 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |