Forum Discussion

marma330's avatar
marma330
Helper I
5 years ago

When exporting dataset to Rstudio it gets summed

I am using R in Power BI, and when I export the dataset to Rstudio, they get summed not sure why...

 

Here is my data:

 

 

When I try to use it in R:

 

 

Why is this happening? I need the full dataset, not summarized... I can't get the fulldataset in R...

Show and Tell

1 Reply

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    Hi, marma330 

     

    All R data source settings must be set to Public. All other steps in a Power Query Editor query must also be public. You may try going to 'Data source settings' dialog box, select one or more data sources, and then select 'Edit Permissions' and set 'Privacy Level' to 'Public'.

     

    For further information, please refer to the document .

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.