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.

best,tomaž

Hi,

thanks for your reply.

So you get error with the PowerBi file that is available with the article?
Which sheet does the problem?

What you...

🙂 And what is your point of view on this topic, regardless of different point of views (or not).

best

INCREDIBLEmouse (9/30/2016)

tomaz.kastrun (9/30/2016)

you can install package in RTVS (VS R IDE).

IMHO IDE should be prepared for e.g.: client machine with all packages pre-installed (compatible with version), so data...

Great to hear. Hope you enjoyed it.

Best, Tomaž

Hi,

you can install package in RTVS (VS R IDE).

IMHO IDE should be prepared for e.g.: client machine with all packages pre-installed (compatible with version), so data wrangled, data...

Hi David,

Thank you for pointing out the model DB is not a one of the system database, but a new database for modelling purposes.

Well model can not only...

Thanks you for spreading the word 🙂

best, Tomaž

Hi,

you can use this:

create table #temp

(

id int identity(1,1)

,name varchar(50)

,calc as char(65) + convert(varchar(10), getdate(),112) + convert(varchar(20), id, 0)

)

and it should work.

Best, Tomaž