I'm looking to publish my formatted Report Builder tables to Power BI. This works - fantastic!However, I want to be able to select which Power BI Workspace this dataset is published to - am I missing something here as I don't see an option.Thanks,Jack

Hello,I'm trying to work out how many Orders contain a single unit of a specific department (classification from Product string), versus Orders that contain > 1 unit of a specific department.The below doesn't work for Single Units as I don't want to exclude Orders containing other Departments Likewise, the below doesn't work for Multiple Units - this doesn't necessarily mean there's more than 1 Unit of the desired Department, just that there's more than 1 Unit in total in the orderAny help would...