Viewing 15 posts - 1 through 15 (of 22 total)
Couple of shorter solutions:
--Solution 1SET DATEFIRST 1DECLARE @d DATE = '2016-05-13 00:00:00.000'--GETDATE()WHILE (@d < '2099/01/01') BEGIN IF DATEPART(dw,DATEFROMPARTS(YEAR(@d),...
May 7, 2018 at 11:53 am
sorry for late response.
This looks to me that ROCR is not available at the right location from where you are calling this R script. So...
September 4, 2017 at 6:45 am
Thank you Nick,
Agree with your points. Thank you for point them out and thumbs up on article. 🙂
July 6, 2017 at 2:54 am
Hi Nick,I would be careful as to what type of data to be used in PCA, as this algorithm is sensitive to types of data (nominal, ordinal, categorical, interval)....
July 5, 2017 at 12:08 am
thanks for feedback.
Yes, you have to install it manually.
There is an article on how to install missing packages in R: http://www.sqlservercentral.com/articles/R+Package/145571/I...
February 16, 2017 at 12:03 am
I can not reprocduce the error 🙁 Try to handle the datatypes in report. maybe the image is in wrong format. Can you try that.
February 12, 2017 at 2:43 am
Glad that this is working.
then just double check all the settings in SSRS, that datasets are correctly set.and I strongly suggest that you also execute the stored procedure in...
February 11, 2017 at 11:52 am
Very good.Have you tried to execute only a simple R script that will return a dataframe / table in SSRS?
For example create simple procedure like:[code...
February 11, 2017 at 6:36 am
cool.and can you also run the Procedure for SSRS and the code for powerBI? including the one where you are referring to the ggplot2 package?
February 11, 2017 at 5:12 am
can you run R code using sp_execute_external_script on your SQL Server from SSMS? Try to run the code there, before going into Power BI and SSRS.
February 11, 2017 at 4:44 am
thanks for your reply.
So you get error with the PowerBi file that is available with the article?Which sheet does the problem?
February 11, 2017 at 3:58 am
Can you please shed some light on confidence and support for the last...
January 21, 2017 at 9:02 am
I was wondering why you did not use the CustomerKey when you created the...
January 21, 2017 at 8:35 am
January 17, 2017 at 11:14 pm
January 17, 2017 at 12:39 pm