RyanMesser Posted July 31, 2018 Share 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 Link to comment Share on other sites More sharing options...
James Ainsworth Posted July 31, 2018 Share 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 Link to comment Share on other sites More sharing options...
RyanMesser Posted August 1, 2018 Author Share Posted August 1, 2018 Hi James, Version of what Power Bi or R? Thanks Ryan Link to comment Share on other sites More sharing options...
RyanMesser Posted August 1, 2018 Author Share Posted August 1, 2018 Hi James, I'm on version 1.1.0 of PowerBi. Thanks Ryan Link to comment Share on other sites More sharing options...
RyanMesser Posted August 1, 2018 Author Share 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. Link to comment Share on other sites More sharing options...
James Ainsworth Posted August 1, 2018 Share 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. Link to comment Share on other sites More sharing options...
RyanMesser Posted August 2, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
Victor Posted August 7, 2018 Share 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... Link to comment Share on other sites More sharing options...
RyanMesser Posted August 10, 2018 Author Share Posted August 10, 2018 @Victor I have PM'd you. Ryan Link to comment Share on other sites More sharing options...
RyanMesser Posted October 8, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
RyanMesser Posted October 10, 2018 Author Share 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 Link to comment Share on other sites More sharing options...
James Ainsworth Posted October 10, 2018 Share 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 Link to comment Share on other sites More sharing options...
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