Forum Discussion

ChrisRenlund's avatar
ChrisRenlund
Advocate I
5 years ago
Solved

PowerShell script example on how to run full refresh of incremental dataset?

Is there anyone who can provide a code example on how to write a Powershell script that runs a full refresh of a dataset that is configured for incremental refresh?   We refresh our datasets by pow...
Need Help
  • ChrisRenlund's avatar
    ChrisRenlund
    5 years ago

    Found out how to pull it off.

     

    You create a .json file with this information:

    {
"refresh": {
"type": "full",

		"applyRefreshPolicy": false,

		"objects": [
			{
				"database": "Your Dataset Name"
			}
		]
	}
}

    Then you create an Powershell script-file:

    #Set Credentials
$userName = "[email protected]"
$password = ConvertTo-SecureString -String "YourPassword" -AsPlainText -Force
$Credential = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $userName, $password


#Execute refresh 
$InputFileRefresh ="D:\MyJsonFile.json"
invoke-ascmd -Server "powerbi://api.powerbi.com/v1.0/myorg/Your Workspace Name" -InputFile $InputFileRefresh -Credential $Credential

    That runs a full refresh of the dataset (but you won't see it running in the Power BI service and the Last Refresh Date in the PBI service will not be updated, just the data in the dataset).

Clement_lsc's avatar
Clement_lsc
Frequent Visitor
4 years ago

Ok thank you for your answer. ðŸ˜€

What module did you downloaded in order to run "Invoke-ascm" ? 
I have an error message " invoke-ascmd' is not recognized as the name of a cmdlet" even with the Sqlserver and MicrosoftPowerBIMgmt.Profile modules. 

Sorry i'm a beginner... 

Thank you for your time. 

ChrisRenlund's avatar
ChrisRenlund
Advocate I
4 years ago

It seems as it is part of the SqlServer module (https://docs.microsoft.com/en-us/powershell/module/sqlserver/invoke-ascmd?view=sqlserver-ps)

These are the modules I have on the server where the script is running (you can get yours with the Get-InstalledModule command):

VersionNameRepositoryDescription
3000.10... DataGateway PSGalleryData Gateway PowerShell cmdlets
3000.10...DataGateway.ProfilePSGalleryData Gateway PowerShell - Profile credential management cmdlets for Data Gateway
1.12 Microsoft.ADAL.PowerShell PSGallery ADAL module for PowerShell
21.1.18230SqlServerPSGallery This module allows SQL Server developers, administrators and business intelligence prof...

 

  • Clement_lsc's avatar
    Clement_lsc
    Frequent Visitor
    4 years ago

    Hello Chris, 

     

    I managed to fix my script. It works now !
    I had some securities on my laptop that blocked the SQL SERVER module. 
    Moreover, I had to change a parameter in Power BI service to make it work (XMLA authorizations). If some of you encoutered the same issue, here is the solution : 

     

    Pass it to read/write. 

    Thank you Chris, have a nice day. 

    Clément 

  • Clement_lsc's avatar
    Clement_lsc
    Frequent Visitor
    4 years ago

    Thank you. 
    It seems that I have the module, now I have an error message saying the cmdlet was found in the sqlserver package but could not be charged...

    I'll find a way, thank you for your time. 
    Have a nice day. ðŸ˜€
    Clément