User Profile
danthu
Helper I
Joined 9 years ago
User Widgets
Contributions
Re: Using PowerBI table as data source for R Script Query
Ok, that's a pity that I can't use the data in the Power bi directly. Any specific reason why this is not available? I guess I will have to manually export to a .csv file everytime I want to use the data then. I was hoping this would not be needed. I need the relationships to the other tables in order to be able to recreate the calculated columns. Can I use the relationships inside the query editor?5.2KViews0likes2CommentsRe: Using PowerBI table as data source for R Script Query
Hi v-qiuyu-msft, Exactly, I want to run the R-script based on the entire table inculding calculated columns. Do I have to recreate these columns in the in the query editor? Isn't there anyway to use the power BI table directly? I'm not even sure if I can recreate the calculated columns in the query editor as many of them depends on relationships with other tables, would that be possible? Also I would not be able to use the DAX language inside the query editor I guess?5.2KViews1like4CommentsRe: Using PowerBI table as data source for R Script Query
I would like to simpify my question a bit. Basically I have a table in PowerBI that comes from a query but also has a lot of added calculated columns. I want to use the data in this table as input data in my R script to perform some machine learning algorithms. I cannot use the query table directly beacuse it is mainly the values in my calculated columns that I need for running the machine learning models. So, is there any way to publish the content of a Powerbi table to a SQL database or something so that I can load it in again as a new R script query? Or is the only way of using the table data outside of Power BI to extract it into a .csv file?5.2KViews0likes6CommentsUsing PowerBI table as data source for R Script Query
I have an R script that I would like to run on one of my tables in PowerBI and then store the results in a new table. Is this possible? So far I have only been able to do this by first extracting my PowerBI table into a .csv file and then use it as a data source for my R Script Query. This is however not very efficient as I would like my tables generated from the R Script query to update as soon as my PowerBI table used as data source for the R script updates. I know I could use the PowerBI table to create R Script visuals but I rather want to have the results stored in a table that I can visualise using PowerBI visualisations instead. Any solution or workaround for this problem would be much appreciated! Thanks!5.2KViews1like7CommentsRe: Display results from a machine learning output in R
I solved the prolem of loading files in the script. I just had to set the working directory specifying the full path instead of relative. However now I have encountered another error message: We encountered an error while trying to connect. Details: "Unable to translate bytes [E4] at index 0 from specified code page to Unicode." Can anyone explain to me what this means?2.1KViews0likes1CommentRe: Display results from a machine learning output in R
Thank for your reply. I am using the caret package for machine learning which should be supported? I understand that I have to run the entire code in PowerBI however I'm trying to figure out if it is possible to use a model that I have allready trained and npt having to retrain the model each time I want to do a prediction. I have the model object stored as a .rda file. I can load that model in RStudio with load() without any problems. But when I try to do load() in PowerBI it can't find or open the model object. Also in the PowerBI R query when I try to load data from a .csv file with read_csv() it cannot find the file. I have tried placing the files both in my RStudio working directory and in the R home directory specified by PowerBI. Can anyone explain why I get this error?2.1KViews0likes2CommentsDisplay results from a machine learning output in R
Hi, I have built a machine learning model in RStudio based on data exported from PowerBI Desktop. Now that I have my model I would like to use it for classifying new data points as they arrive after refreshing the data in PowerBI. Then I would like to either store the results in a new table in PowerBI that I can use for visualisations or use the R output directly for visualisations. As I understand it I should be able to use the functionality to base a PowerBI visualisation on a R script to do this. The problem is, if I just copy my R code into PowerBI it will train a new model based on the updated data each time I refresh the data in PowerBI, right? I do not want to retrain my model, I just want to use the already trained model for doing predictions on yet unlabelled data. Is it possible to let PowerBI use my already trained model without running through the entire script and thus retraining the model on new data?2.3KViews0likes4CommentsRe: Using ALL() on Date column to ignore Date Slicer
Thanks, I still don't understand why it does not work in my case. Could you please explain why I'm getting that behaviour? Simply what I want to do is divide the outcome of Measure2 with the outcome of Measure1 when Measure1 is only filtered by Slicer1 and Measure2 only filtered by Slicer2. Is there any way to work around this and store the outcomes of my separate measures and then just dividing them? It seems so simple, I just want to divide two numbers that are there in my report, still I can't figure out how to do it. Any suggestions are very much appreciated!2.2KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.