I have an issue with just the subcategory field on the power bi connector. It is an available field in the query1 when I first connect to the data source and create my report and then a couple days later after doing a data refresh to get the latest data, the subcategory field will disappear and doesnt come back after doing several refreshes.
I created a new report thinking it was a problem with my first report, but the issue continues to happen on the new report.
Is anyone else experiencing this, or a known issue?
Thanks,
Bryan