Power BI Desktop access to ODBC System DSNs
In my environment we currently use SSRS reports to pull Remedy metrics and are looking to convert some of them over to Power BI desktop reports. In order to access this data we have to setup a 32-bit System DSN based on the AR System ODBC Driver. While I can connect up to Remedy in this fashion i...
Install R Packages without Opening Power BI in "Run as administrator" Context
Playing around with using R to add visuals to a report, specifically a word cloud. Unfortunately I found that when trying to install packages that did not come with the MRO base install I got "access denied" because the account did not have access to write to the library folder where R was instal...
tm Access to Power BI Datasets/External Databases
Trying to add an R word cloud in Power BI Desktop using the following example: http://community.powerbi.com/t5/Desktop/R-Visuals-word-clouds-and-automatic-removal-of-unique-values/td-p/19726 However, as mentioned in the link the tm package seems to only be able to read data from a local file. T...
BMC Remedy ITSM Data Source
BMC has not updated the ARSYS ODBC provider in forever, have stated that they will and it is only available in 32-bit. Also, it is sill the most viable way to pull data out of Remedy or ITSM for use by external analytic tools. It would be great if Microsoft could work with BMC to create a new da...