I have run into an issue when attempting to update and add new queries in BI.
When adding a SQL query with no additional steps, the preview runs, but when I go to apply it, it doesn't do the query type selection and then doesn't apply the changes. It still notifies me that here are changes to be made but does not complete them; even when hitting the Apply button outside of the query editor.
I have even started new BI files with nothing in them to try it and it just doesn't work. The I've already tested the SQL query so I know it does work and how large it is and how long it would take normally.
Please help... how do I fix this?
Thanks in advance...
When adding a SQL query with no additional steps, the preview runs, but when I go to apply it, it doesn't do the query type selection and then doesn't apply the changes. It still notifies me that here are changes to be made but does not complete them; even when hitting the Apply button outside of the query editor.
I have even started new BI files with nothing in them to try it and it just doesn't work. The I've already tested the SQL query so I know it does work and how large it is and how long it would take normally.
Please help... how do I fix this?
Thanks in advance...