< Back

Export-PBIDesktopToCSV

Sat Jan 18, 2020 8:40 pm

NAME Export-PBIDesktopToCSV



SYNOPSIS

A way to export all your Power BI Desktop model tables into CSV files





SYNTAX

Export-PBIDesktopToCSV [-pbiDesktopWindowName] <String> [[-tables] <String[]>] [[-daxQuery] <String>]

[-outputPath] <String> [<CommonParameters>]





DESCRIPTION

A way to export all your Power BI Desktop model tables into CSV files





PARAMETERS

-pbiDesktopWindowName <String>

Power BI Desktop window name, wildcards can be used. Ex: "*name*"



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-tables <String[]>

The tables to be exported - if empty all the tables get exported



Required? false

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-daxQuery <String>



Required? false

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-outputPath <String>

Path to the output folder



Required? true

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Export-PBIDesktopToCSV -pbiDesktopWindowName "*Van Arsdel*" -outputPath ".\\CSVOutput"















RELATED LINKS