Forum Replies Created
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.October 25, 2016 at 9:30 pm in reply to: Newbie Help. Per Day measurement based on number of days in a month #6564
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.
Indeed I was using 2016. Suggested fix worked. Thanks.
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.
I ended up reinstalling under the new user name.
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.
I forgot to add…No, the “Disable Power SQL Update” in the PU Manager is not checked.
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.
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.
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.