topic Re: How can i get the SharePoint or File locations of a DataSource using PowerShell in Developer

How can i get the SharePoint or File locations of a DataSource using PowerShell

Anonymous — Sun, 03 Jan 2021 16:40:01 GMT

hello all

I am trying to find out the location of a Datasource SharePoint or File.

when i run the PowerBIDatasource PowerShell cmdlet it does not return that detail

thanks in advance

lbendlin — Mon, 04 Jan 2021 22:10:52 GMT

You need to run DMV queries against the XMLA endpoint to get that information

select * from $SYSTEM.TMSCHEMA_PARTITIONS

V-lianl-msft — Tue, 05 Jan 2021 05:53:40 GMT

Hi @Anonymous ,

You need to invoke the rest API.

Please try:

Invoke-PowerBIRestMethod -Url 'groups/xxxxxxxxxxx/datasets/xxxxxxxxxx/datasources' -Method Get

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