Forum Replies Created

Viewing 15 posts - 1 through 15 (of 190 total)
  • Author
    Posts
  • in reply to: Changing Target File in Action #12443

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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.

    in reply to: power update refresh task list #11237

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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.

    in reply to: Power update Schedule frequency #10198

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    Try the weekly option, there you should be able to select the weekdays.

    in reply to: New users cant get excel workbook to refresh data #9144

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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.


    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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)

    in reply to: Power Update – SQL on Another Domain Authentication Woes #8490

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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

    in reply to: "Update SQL Data" greyed out #8489

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    It should be available in the 30 day trial version, but not the Free version


    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    Try updating to the latest version by re-downloading the setup

    in reply to: PowerUpdate Crashes #8278

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    Make sure you are running PU as administrator and you have .NET 4.7 with all sub-components installed.


    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    We’ve fixed the issue, please update to the latest version by re-downloading the setup.

    in reply to: Powerpivot + ODBC + PowerUpdate + Microsoft Server 2008 R2 #7446

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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.

    in reply to: E-mail setup #7344

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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.

    in reply to: SQL Update in Power BI #7341

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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)

    in reply to: Powerpivot + ODBC + PowerUpdate + Microsoft Server 2008 R2 #7340

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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).

    in reply to: E-mail setup #7328

    Charles
    Moderator
    • Started: 2
    • Replies: 190
    • Total: 192

    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:
    http://www.mrexcel.com/forum/excel-questions/710212-visual-basic-applications-code-convert-excel-pdf-email-attachment.html

Viewing 15 posts - 1 through 15 (of 190 total)