Convert-PowerBIDesktopToASTabular

NAME Convert-PowerBIDesktopToASTabular



SYNOPSIS

A quick way to convert a Power BI Desktop file into an Analysis Services Tabular Project





SYNTAX

Convert-PowerBIDesktopToASTabular -pbiDesktopWindowName <String> -outputPath <String> [-compatibilityLevel

<Int32>] [-removeInternalPBITables] [-modelFileName <Object>] [-onlyModel] [<CommonParameters>]



Convert-PowerBIDesktopToASTabular -pbiDesktopPbiTemplatePath <String> -outputPath <String> [-compatibilityLevel

<Int32>] [-removeInternalPBITables] [-modelFileName <Object>] [-onlyModel] [<CommonParameters>]





DESCRIPTION

A quick way to convert a Power BI Desktop file into an Analysis Services Tabular Project





PARAMETERS

-pbiDesktopWindowName <String>

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



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-pbiDesktopPbiTemplatePath <String>

Path to PowerBI Template



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-outputPath <String>

Path to the output folder



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-compatibilityLevel <Int32>



Required? false

Position? named

Default value 1400

Accept pipeline input? false

Accept wildcard characters? false



-removeInternalPBITables [<SwitchParameter>]

This remove internal tables like "Localdate_XXXXXX"



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-modelFileName <Object>



Required? false

Position? named

Default value model.bim

Accept pipeline input? false

Accept wildcard characters? false



-onlyModel [<SwitchParameter>]



Required? false

Position? named

Default value False

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:\\>Convert-PowerBIDesktopToASTabular -pbiDesktopWindowName "*VanArsdel - Sales*" -outputPath ".\\SSASProj"















RELATED LINKS