Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Activity ID: | 9313b16c-78f0-4268-9f74-0905e78ab55a |
Request ID: | 74961647-e14d-433c-c9c5-082010460226 |
Status code: | 400 |
Time: | Sun Dec 30 2018 16:15:39 GMT+0000 (GMT Standard Time) |
Version: | 13.0.7683.237 |
Cluster URI: | https://wabi-north-europe-redirect.analysis.windows.net |
We are having a similar issue on my team.
When attempting to provide the R credentials on the powerBI site, the I get the same error as op.
However, when I setup a personal gateway on my laptop that I use for work everyday, everything works fine!
I clicked the 'edit credentials' used the default only option of 'WindowsWithoutImpersonation' and set up an auto refresh and it all worked...
I then tried to replicate this on another system to free up my laptop, but and I ended up with the same error as before.
I can only get this working on my personal laptop.
On all three systems, I'm running:
R 3.5.1
Personal Gateway 3000.0.265
Hey there
I decided to revert back to September release and this works.
Hi @Anonymous,
How do you revert to September release?
Thank you,
Hey Pedzilla,
Im glad to hear you got it working!
You rolled back to September release of R or PowerBI Personal Gateway?
yes I did 🙂
I think the problem might have to do with mash up data source. I got my data from Oracle database then transform it using R script. Then Power BI might be asking for the credential of my Oracle database while I'm supplying it with R credential. I remember there used to be more option for authentication method. Not sure why there is only one option now. @v-shex-msft
I haven't found any work around yet @Anonymous
Is there any way that I could download the old version of personal gateway @v-shex-msft
I'm in the US so I guess North America.
For this issue, I remember there used to be more options for the Authentication method, not just WindowsWithoutImpersonation.
Yeah thats true! Now there are no other options.
@v-shex-msft what is your region please?
@tqbao27 so you are in a different region to me so maybe region has nothing to do with that.
I wonder what version of personal gateway that @v-shex-msft has installed? Maybe its not December release.
Hi @Pedzilla1,
I try to install last version of personal gateway and test with r script(3.5.1), but they all works. Maybe you can open a support ticket for better support.
Regards,
XIaoxin Sheng
Hi @Anonymous,
My data are stored on 'west central US'.(you can find it on click on power bi service-> about)
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Can you please share a pbix file with some simple data and r script who can reproduce that scenario?
I will test on my side and report to power bi team if I can reproduce this issue.
BTW, I can use personal gateway to refresh r script sample file.
Regards,
Xiaoxin Sheng
Is it possible you can share your pbix file so i can try it here please? @v-shex-msft
Also what is the version of your gateway?
I wont be able to share my file due to network / firewall.
However its a generic dataset - here is the M code - hope you can help.
let
Source = R.Execute("cars = data(mtcars)#(lf)mtcars$date = Sys.time()"),
mtcars1 = Source{[Name="mtcars"]}[Value],
#"Changed Type" = Table.TransformColumnTypes(mtcars1,{{"date", type time}})
in
#"Changed Type"
Thank you so much
HI @Anonymous,
I test with my sample and your code, they all works well.
I think this issue may relate to data region service of power bi, maybe you can try to use fiddler to trace these httprequests of refresh operation.
BTW, I also attached sample files which I tested at below.
Regards,
Xiaoxin Sheng
Hey there I am based in the UK. Can I actually change the region on my personal gateway?
I will try your sample now.
Your sample doesnt work when I tried on my personal gateway. I dont suppose we can change that can we?
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |