Forum Discussion

Kumar11109's avatar
Kumar11109
Helper IV
8 years ago

Extract data from PowerBI

Dear All,    I need to extract data from power bi, but I need to that without sampling of data occuring. Please help me. If R can be ustilised then I am sending you the code that I wrote by reading...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Kumar11109,

 

According to the error message, you may need to firstly install the 'gdata' package with R Studio(or other R GUI tools), in order to run the r script in Power BI Desktop. Here is an article about how install R Studio and R packages for your reference.

 

Note: There is also a limitation for using R in Power BI that data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.

 

In addition, here is the idea for increasing Export Data Limits. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

 

Regards

  • Kumar11109's avatar
    Kumar11109
    Helper IV
    8 years ago

    v-ljerr-msft

     

    But I have already installed R Studio, and required gdata package. But it still showing this message?? :-C