Power BI API via Powershell using Get-Content

[powerbi_jenhen]

Hi,

I want to read the contents of a text file to set deployment artefacts for my Power BI Service deployment pipeline using the Power BI Rest API.

My Reports.txt file looks like:

reportOne.pbix

reportTwo.rdl

Using Get-Content, how can I filter the content of the text file to just the .pbix line?

I tried the below but it returns both lines:

$pbix_reports = Get-Content "C:\Temp\Reports.txt" -Filter *.pbix

Thanks.

[powerbi_jenhen · Accepted solution]

Figured this out:

$pbix_reports = Get-Content "C:\Temp\Reports.txt" | Select-String -Pattern ".pbix" -AllMatches