RyanMesser Posted July 31, 2018 Posted July 31, 2018 Hi, A couple of issues I have with trying to pull a report with R in PowerBi using one of your scripts from github. If I keep in the line if(runID > 0) it tells me the argument is of the length of zero when the report has been run 3 times previously. If i take that line out I get further but then I get - Error in grepl(runStatus, "completed") : invalid 'pattern' argument Thanks Ryan
James Ainsworth Posted July 31, 2018 Posted July 31, 2018 Hi Ryan, Could you do a quick check to see if you are on the latest version. There was an update on June 28th. This may not fix your issue but always worth checking, just in case. The current version is 1.1.0 Regards, James
RyanMesser Posted August 1, 2018 Author Posted August 1, 2018 Hi James, Version of what Power Bi or R? Thanks Ryan
RyanMesser Posted August 1, 2018 Author Posted August 1, 2018 Hi James, I'm on version 1.1.0 of PowerBi. Thanks Ryan
RyanMesser Posted August 1, 2018 Author Posted August 1, 2018 I assume its something to do with the runID, the only reason I can see that the script returns "argument is length of zero" is if runID input is the length of zero? I don't know if that parameter has changed but the only reason I can see why it says what is says.
James Ainsworth Posted August 1, 2018 Posted August 1, 2018 Hi @RyanMesser Sorry, my post wasn't very clear. It was the version of the Hornbill script available no https://github.com/hornbill that I was suggesting having a look at.
RyanMesser Posted August 2, 2018 Author Posted August 2, 2018 Hi James, No worries yes that's the version of script I'm using in which I get these errors. Ryan
Victor Posted August 7, 2018 Posted August 7, 2018 @RyanMesser - in your script, what is the configuration/values for reportID and reportComment please? Can you also PM me the API key...
RyanMesser Posted October 8, 2018 Author Posted October 8, 2018 Hi, Still having the same issue, tried creating the a blank report (no filters or anything) and trying to run powerbi but exactly same error. Ryan
RyanMesser Posted October 10, 2018 Author Posted October 10, 2018 All, Worked out that the API key wasn't authenticating so I created a new one and it ran fine, i guess this is why the runID was returning NULL which is what the argument is length of zero means. Thanks Ryan 1
James Ainsworth Posted October 10, 2018 Posted October 10, 2018 Hi @RyanMesser Thanks for letting us know that you found a solution to this and sorry that we were not able to help. This post can help other customers that might run into the same issue to great to have your solution posted. Regards, James
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now