Just dowloaded and installed sqlwatch
It all seems to work database wise but I cannot get the PowerBi Dashboard to load data from my sql server. Not sure if it matters but I used dbatools and Install-DbaSqlWatch to install.
My problem is the PowerBI Dashboard.Once I change the parameters and apply changes I see the status go from Evaluating to Loading blocked by failures with other queries.
What I have tried so far.
- Always ignore Privacy Level Setting
- Disable parallel loading of tables
- Tried different instances
I do have named instances not sure if that matters?