Consume output from PowerShell script?

Power BI
1

My dev team has created a PowerShell script (.PS1) to get deep-level info from our SharePoint site. They are currently exporting the output as CSV or Excel, which isn’t sustainable. Can I consume the output directly in Power BI?

PLEASE NOTE
We are on Power BI Report Server, the on-prem solution. We are substantially limited compared to the “normal” PBI cloud stuff. (For example, we don’t have the v2.0 SharePoint connector and are testing out API calls as a workaround. Our dev team thinks that a basic API call won’t work for this situation.)

2

Hi @Gaelan,

We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!