SQL TEMP TABLE NOT WORKING IN PBI SERVICE REFRESHES
Has anyone faced an issue where a temp table could not be refreshed in PBI service? I have a basic sql query with one temp table that works perfectly in PBI desktop, but once uploading to PBI service, it always seems to fail with the below error:
My understanding is that if it is working on PBI desktop but not on the service, since it is a on prem gateway, the issue may be related to the gateway. On the other hand , if I do not create a temp table and just do a simple select into the table, there is no issues with the refresh.