Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I have an R-script running in Power Query in PBI desktop which transforms my input data and saves output data as csv in a certain directory (thanks, @curbal!)
Here is the script:
require(gdata)
write.table(dataset, file="xxx, sep = ";", row.names = FALSE, na = "", quote = FALSE);
I am now trying to make it work in Power Bi Service - with scheduled refresh - hoping that the Service will save the csv the same way my Desktop did, but it does not work 😞
Has anyone managed to find a workaround to automate data exporting from PBI Service?
Thank you very much!
Solved! Go to Solution.
HI @Whiskeybar ,
I don't think it is possible to run these script code on power bi service. They will been blocked due to security and permission reasons.
Regards,
Xiaoxin Sheng
HI @Whiskeybar ,
I don't think it is possible to run these script code on power bi service. They will been blocked due to security and permission reasons.
Regards,
Xiaoxin Sheng
Thank you for reply! I will be looking for another workaround , then...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.