How to find R visual in a report with over 30 pages?

[Anonymous]

I opened a .pbix with over 30 pages, at the begining I got a warning saying that there were some R code, and that I should install some libraries....

I was reviewing some other pages, but now I want to know where R is used (in which page and visual...). I guess I can open each page and click every visual until i see the R icon highlight (in the Visualizations section), but that would take too long, is there a simpler way?

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[Anonymous]

@lbendlin  I haven't found "provider" in the layout file, so I guess @mahoneypat  is right. How can I search for this R.execute ? I am unable to find it...

[Anonymous · Accepted solution]

Hi @Anonymous 

In addition to  lbendlin ‘s reply,the Layout file contains all the information with regards to the Report Layout. Which is essentially the report sheets, as well as the placement of the visuals and all of their related properties.

You can try to find R visual in Layout file in pbix file.

For more details about what makes up the pbix file, you may refer to this blog.

In my test I have two pages and each page contains a R visual.

Open pbix file by zip and find Layout file.

Firstly we need to find 'Page'.

Use Enter to wrap the contents of different pages. This will make it easier to distinguish which page the R visual is on.

Then find 'R', and find the Property to get the visual name.

From Page1:

\"provider\":{\"expr\":{\"Literal\":{\"Value\":\"'R'\"}}}}}]}}}","filters":"[]","query":"{\"Commands\":[{\"SemanticQueryDataShapeCommand\":{\"Query\":{\"Version\":2,\"From\":[{\"Name\":\"t\",\"Entity\":\"Table\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"t\"}},\"Property\":\"Column2\"},\"Name\":\"Table.Column2\"}]}
...

We know that R visual Column2 is in Page1.

From Page2:

\"provider\":{\"expr\":{\"Literal\":{\"Value\":\"'R'\"}}}}}]},\"vcObjects\":{\"title\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'Test2'\"}}}}}]}}}"...

 We know that R visual Test2 is in Page2.

Best Regards,

Rico Zhou

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

[mahoneypat]

Consider that there also may be an R.Execute function in one of your queries too (not just an R visual).

Pat

[lbendlin]

search for the provider string

[Anonymous]

I have opened the file, how can I query against the metadata? I have searched for 'reshape' or 'ggplot' (R libraries) but it retruns nothing...

I have also opened every page and selected every visual... and there are no R visuals, and I still get a pop up whenever the report is opened. (The pop up says that R visual won't work without libraries installed).

[lbendlin]

If by "simpler" you mean running queries against the report meta data - sure. Export the file as a template, then open the result with a ZIP viewer (like 7-ZIP). The visuals are listed in the Report\Layout file.