Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Need assistance: R script output to get automatically refreshed

Hi,

 

I have few R visuals which I need to convert into Power BI visuals. I have been provided with R script with static R visuals. I now need to make those R Visuals dynamic. One approach I have taken is as follows:

 

1. Generate an output file with R script (into data table/excel/csv), and stored at a folder/location.

2. I have linked this file with powerBi to create power BI visuals, with a slicer to generate user driven dynamic views

 

R script runs when user changes the selection inthe slicer, and likewise, my output file is also refreshed at folder location.

 

When user changes selections in Slicer, Power BI linked file is not getting refreshed automatically everytime R script runs.

 

I have a refresh option in the menu bar but it is a manual refresh option. Is there any way where linked data can get automatically refresh based on the slicer selections??

 

Thanks,

Naveen Koushal

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@Anonymous,

In Power BI Desktop, when the data source(output file in your scenario) changes,  the visuals in Power BI Desktop can get updated only when clicking Refresh button.

You can publish the PBIX file to Power BI Service, configure gateway and set schedule refresh for the dataset. This way, Power BI Desktop can be refreshed automatically.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi,

 

Thanks for sharing the information. As an alternative solution, is there any way where this challenge can be overcome.

Can you please suggest other alternative solution.

Just for the more clarity, I am reiterating the problem:

I have some visuals which is created from R script visuals. Since, R visuals are not impressive and also there is no drill down functionality I therefore need to convert them into power BI visuals. I can do this using DAX however due to slowness of DAX function I am not allowed to use DAX. Please suggest any other solution apart from using DAX.

 

Regards,

Naveen

Anonymous
Not applicable

Hi,

 

I have few R visuals which I need to convert into Power BI visuals. I have been provided with R script with static R visuals. I now need to make those R Visuals dynamic. One approach I have taken is as follows:

 

1. Generate an output file with R script (into data table/excel/csv), and stored at a folder/location.

2. I have linked this file with powerBi to create power BI visuals, with a slicer to generate user driven dynamic views

 

R script runs when user changes the selection inthe slicer, and likewise, my output file is also refreshed at folder location.

 

When user changes selections in Slicer, Power BI linked file is not getting refreshed automatically everytime R script runs.

 

I have a refresh option in the menu bar but it is a manual refresh option. Is there any way where linked data can get automatically refresh based on the slicer selections??

 

Thanks,

Naveen Koushal

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors