Forum Replies Created
The source file is set in %localappdata%\Power Update\Settings.xml
You can either create a bat/powershell script to replace the source file in the setting.xml and schedule that script monthly in windows task scheduler.
Or you can create a symbolic link or shortcut that points to the current file, set that as the source file in Power Update, and update the link manually or through a scheduled bat/powershell script monthly.
To change the refresh frequency:
Go to C:\Program Files\PowerPlanner\Power Update and look for PQRefreshManager.exe.config. Copy that file to the Desktop in order to edit it. Open the file with a text editor, look for TaskListRefreshPeriodand set it to the desired value (in ms). Save the file and copy it back to the original location. Restart Power Update to take effect.
Try the weekly option, there you should be able to select the weekdays.
If you are using Excel 2013 or 2016 try setting the RefreshEachConnection setting to False in C:\Program Files\PowerPlanner\Power Update\PQRefresh.exe.config (copy the file to desktop, change setting in notepad, save, and copy it back). This does a Refresh All instead of Refreshing connections individually.October 24, 2017 at 2:20 pm in reply to: Refreshes no longer working following October 2017 PowerBI desktop update #8514
Please re-download and re-run the setup, and also make sure that your Power BI Desktop is up to date (2.51.4885.701 or higher)October 18, 2017 at 2:31 pm in reply to: Power Update – SQL on Another Domain Authentication Woes #8490
If you have a SQL login (not windows) you can specify it under Options \ Data Source Passwords.
You can also save it in the workbook:
o Edit the PowerPivot connection
o Enter the password
o Check the ‘Save Password’ check box
o On the Excel ribbon, select the ‘Data’ tab
o Select ‘Connections’ to open the ‘Workbook Connections’ dialog
o Select the connection used in the PowerPivot model and select ‘Properties’
o Check the ‘Save Password’ check box
o Press Refresh All (if get prompted for the password, enter the password)
o Save the workbook
It should be available in the 30 day trial version, but not the Free versionOctober 18, 2017 at 2:14 pm in reply to: Refreshes no longer working following October 2017 PowerBI desktop update #8488
Try updating to the latest version by re-downloading the setup
Make sure you are running PU as administrator and you have .NET 4.7 with all sub-components installed.July 27, 2017 at 11:58 am in reply to: PowerON PBI Integration Desktop – Login Window Every 15 Seconds #8192
We’ve fixed the issue, please update to the latest version by re-downloading the setup.January 31, 2017 at 4:02 pm in reply to: Powerpivot + ODBC + PowerUpdate + Microsoft Server 2008 R2 #7446
The error could also mean that the Power SQL Update addin got disabled in Excel, make sure it’s enabled in addins and is visible in the ribbon.
If you copied the files and don’t use Exce 2016 then reinstall Power Update to get back the previous dll files matching the Excel version.
Unfortunately Excel 2010/2013 doesn’t have a PDF printer installed by default, and the printing settings that yield the expected results for a given workbook are usually custom. But we’ll put it on the backlog to provide an option that better suits most users. Meanwhile you can use the above suggestion.
Not sure what you’re referring to. There’s currently a Power SQL Update Excel addin installed with Power Update that enables exporting PowerPivot data (Power Query results) to SQL tables. (If you’re referring to exporting Excel tables to SQL, you can add Excel lists to the datamodel, and then they become exportable by the Power SQL Update addin)January 23, 2017 at 5:39 pm in reply to: Powerpivot + ODBC + PowerUpdate + Microsoft Server 2008 R2 #7340
If the workbooks all have the same data, then you can update workbook into a shared folder that’s visible by all users. and only run the update process under one user. If the workbooks are different for each user you can either configure jobs under each user profile or configure them under one user and set the target folder for each user’s files respectively to a shared folder that the user has access to.
Regarding to the error message below, if you’re using Excel 2016 please copy the contents of C:\Program Files\PowerPlanner\Power Update\xl2016 to C:\Program Files\PowerPlanner\Power Update (back up the files before overwriting them).
If you’d like to apply a custom page layout, you can add a simple macro that you call at the end of refresh, to generate the PDF using a PDF printer with custom printing areas and resizing options, and send that in email: