Forum Discussion
Creating a Report from PowerBI API
Hello - I thought this would be a common request, but can't seem to find much in the forums 🙂 We're trying to create an Operational Health Dashboard (in PowerBI) for our PBI reporting environme...
Hi there
This certainly can be done when I have used the API with PowerShell
You have to always first authenticate which will then store the authenticated token as part of the call to Power BI.
Here is a blog post explaining how to get this done
https://powerbi.microsoft.com/en-us/blog/working-with-powershell-in-power-bi/
This certainly can be done when I have used the API with PowerShell
You have to always first authenticate which will then store the authenticated token as part of the call to Power BI.
Here is a blog post explaining how to get this done
https://powerbi.microsoft.com/en-us/blog/working-with-powershell-in-power-bi/
Thanks, and that is the route we're already going down.
My question to you is: Is there a way to fully automated that process? Meaning, is there a way to do all this through a scheduled data refresh that authenticates the powershell commands, download the json, and loads the json data into a dataset fully automated without any user interation?
That is the end-goal of this project for us.
Thanks!