Passing (sliced) data to R and then retrieving output object back to Powerbi
I have an application where I have a large dataset in POwerBI and I need to select subsets via slicers (easy) and then pass that subset to R (also easy). Then, for example, I want to run a regression and return a dataframe of coefficients and standard errors back to PowerBI for display not as a visual but in data for presentation in cards/tables, etc. It is easy to subset the data, easy to pass the subset to R, easy to Run (say lm) on that subset and easy to generate a rectangular table of beta estimates an SE (via tidyr::broom), but how do I get the broom-generated output object back into powerBI in real time? I do not want a visual from R, I want data.
How to upload a sharepoint file in powerbi online?
I have access to many files in sharepoint. I want to upload a file from sharepoint in powerbi. However, when I click Upload->Sharepoint. There is nothing but only four empty folders. Does anyone know how to upload a sharepoint file in powerbi online? See below pictures for reference.
Thousand-Separator-and-Decimal-Separator
I have a report with numbers separated by commas when it's thousands. and I have decimal numbers or percentages separated by points but when I publish on the web these digits change, that is, the thousand separator is a point and the decimal separator is a comma.
