Using R scripts for custom visuals requires the data to be related. "Relationships – as with other Power BI Desktop visuals, if data fields from different tables with no defined relationship between...
efglynn
Advocate IV
6 years agoTo get around the restriction, create a "Dummy" dataset with nothing useful in it. Pass the Dummy dataset to the R visual and ignore it! Create the data or get the data from an R package. Not requiring a dataset for an R visual is also a good idea so a good graphics gallery can be created that could connect to data. All the graphics details of working in PowerBi can be resolved in advance before connecting to data. Troubleshooting R problems in PowerBI is not so easy, so getting the graphics to work before trying to connect to data is very useful in my mind. For example, I wasted time last week getting the data ready, and getting the graphics to work in "regular" R only to find out the R package I wanted to use was not supported (yet) in Power BI. So, now I make sure I get an R graphic created first in Power BI, before worrying about connecting to data.
Recent ideas
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels3 hours agoAdvocate IIINew181Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen4 hours agoAdvocate INew293Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi5 hours agoMicrosoft EmployeeNew20Views6likes0Comments