Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KLJ
Helper I
Helper I

R script credentials

Hi

 

I have recently updated the April edition of the Data gateway personal edition.

 

Now I have a problem with the credentials for R Script.

 

R 1.JPG

When I click on Edit credentials and then click Sign in this appears

R 2.JPG

 

I have tried to reinstall the gateway but no thing seems to work.

 

Any idea what is wrong?

 

Thanks

 

Best regards 

Kim

1 ACCEPTED SOLUTION

Hi

 

I tried to turn of custom connections in the gateway and it seems to help.

 

I hope Smiley Happy

 

Best regards 

Kim

View solution in original post

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

Hi KLJ,

 

Are you using R visual in your report? Please update your PBI desktop to the lastest version and try again.

 

Regards,

Jimmy Tao

Hi Jimmy

 

No, I am using R srcipt to save data to a local file.

This is the my R script:

 

require(gdata)
write.table(trim(dataset), file="//Path-to-folder/TEST_PowerBi.txt", sep = "\t", row.names = FALSE, append = TRUE)
plot(dataset);

 

It all worked fine until I updated the Personal gateway to the april edition the other day.

 

My PBI desktop is Version: 2.57.5068.721 64-bit (april 2018)

 

Best regards 

Kim

Hi

 

I tried to turn of custom connections in the gateway and it seems to help.

 

I hope Smiley Happy

 

Best regards 

Kim

Anonymous
Not applicable

Hi, wondering if i can get some help.

 

Basically, i have some CSV's in a network folder.

 

I need to read these Csvs, in Power BI, transform them, and then right them back as new files to the same network folder. 

 

Im pulling my hair out, as I am using R to write the csv, but how do it to write the CSV in the power BI service? I have an on premise gateway and ive added tthe connection to the network folder and that works fine... 

 

whats the best way to go about this?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors