Forum Discussion
How to find R visual in a report with over 30 pages?
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?
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.
7 Replies
- lbendlin
Super User
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.
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
search for the provider string
- mahoneypat
Microsoft Employee
Consider that there also may be an R.Execute function in one of your queries too (not just an R visual).
Pat
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...
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.
