Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • in reply to: SQL Update in Power BI #7386

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    Just as there as an SQL Update add-in for Excel, are there plans for a like add-in in Power BI Desktop.  I assume the answer is no.  I don’t believe Power BI Desktop provides any add-in capabilities.  I was just curious if the same functionality (specifically, the ability to write tables in the data model to SQL Server) could be instantiated in a different way in PBI Desktop.


    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    Report month will always be a calendar month.  Essentially the most granular reporting is a month, but the industry always thinks in output (supply) per day.

    in reply to: Latest version of PU fails to find data model #6292

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    Indeed I was using 2016.  Suggested fix worked. Thanks.

    in reply to: Refresh PowerBI with Power Update #6284

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    I’ll second that.  Also licensed user w/same scenario.  The Help option on PU app leads to outdated documentation.  I have “Check for Updates” enabled, so I assume I am running the latest version of PU.

    in reply to: Power Update fails w/ new user #5261

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    I ended up reinstalling under the new user name.

    in reply to: Update SQL data grayed out #2095

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    Tried activating using the same credentials I use to login to the Power-Planner website.  Activation fails with a ”    Could not validate your License. If you have a License please make that your License information (user, password, edition, supported until, valid until) is correct, your License has not expired, and is not already assigned (Check available Licenses at http://www.power-planner.com/Licenses ). If you’re trying to activate a Trial edition, please make sure that you select the Trial edition in the activation window and that this is the first time Trial activation for this account, and that you have verified your accounts email address.” 

    I checked to see if a had a registered license at http://www.power-planner.com/Licenses.  It indicated that I didn’t have any.

    All of this said, what I desire is to have a functioning free version.  When I came upon Power Update I initially encountered the 30 day trial version and subsequently learned of the free version.  I uninstalled and reinstalled the “free” version.  The Update SQL Data still remains grayed out, but I can initiate new update tasks in the PU Manager.  I guess it’s something at the registry level.

    in reply to: Update SQL data grayed out #2081

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    I forgot to add…No, the “Disable Power SQL Update” in the PU Manager is not checked.

    in reply to: Month Index for Time Series Data #2080

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    Finally getting around to replying.  Many thanks to Tom Allan for his perfect example.  PowerPivotPro has been a great resource for getting me started.  Kudos.

    in reply to: Month Index for Time Series Data #1840

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    Great question on the months with no production.  That’s a fairly common scenario.  You can assume I will have filtered the data model so only months w/ actual production exist; that is, the index represents actual months of production, not the life of the well.  I’m running Excel 2013 (64 bit if it matters).  Many thanks.

    in reply to: Month Index for Time Series Data #1833

    jmg80525
    Participant
    • Started: 14
    • Replies: 10
    • Total: 24

    Tom:

    You are correct in your assessment. The value in ProdMonth needs to be calculated. I put the values in their manually for illustration purposes. The goal is to compare production of multiple wells over their life from month 1 to month n.

Viewing 10 posts - 1 through 10 (of 10 total)