Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Description
Prerequisites (The sample .pbix files will not work without these prerequites completed)
1. Install R Engine
Power BI Desktop does not include, deploy or install the R engine. To run R scripts in Power BI Desktop, you must separately installR on your local computer. You can download and install R for free from many locations, including the Revolution Open download page, and the CRAN Repository.
2. Install the required R packages.
Download the R script attached to this message and run it to install all required packages on your local machine.
Required R packages:
arules, arulesViz, grDevices, gridExtra, grid, methods
Tested on:
CRAN 3.3.1, MRO 3.3.0, , powerbi.com
Legal Disclaimers:
Terms of Service and Third Party Programs.
It did not fail, it says "No rules generated" .
Try to relax thresholds of the rules. If you can to send me PBIX, I will have a look (boefraty@microsoft.com)
I get the same msg when using the Showcase .pbix, "No rules generated"
Tried using different tresholds. I think it's due to using R 3.3.3 / 3.3.2.
Some packages won't load/install under R 3.3.1 using the install-script (were build under R 3.3.3 etc)
Any thoughts?
Hi,
The function "read.transactions" reads a transaction data file from disk and creates a transactions object. The error you get indicates that R could not open the file for reading.
1) Save your excel as CSV for example to : "c:\\Users\\someone\\Downloads\\try.csv
2) Run
txn <- read.transactions("c:\\Users\\boefraty\\Downloads\\try.csv", rm.duplicates= TRUE,format='single', sep='','',cols =c(2,1))
Beside this, you should make sure that your data is a transaction object: to store a binary incidence matrix, item labels, and optionally transaction IDs and user IDs. Check your format is "single" or "basket"
You are welcome to continue and discuss this example with me via email: boefraty@microsoft.com or here