PowerQuery: refresh data for user without it installed

[andrearossi]

I have created a file with a query with PowerQuery.

When I give the file to a user that hasn't installed PQ and he refreshes the data he gets and error!

Is it possibile for the user to refresh the data?

[Anonymous]

If the error is credential/autentication related try going to the existing connections option on the traditional data tab in the standard Excel ribbon, naviagte to the properties of the relevant connection and setting the desired credentials or authentication method under the definiton tab.

I.e. if you are connecting to something like an on prem SQL DB you would need to key credentials here (or define that you want to use windows authentication).

[andrearossi]

Ok, your advice is pertinent... excuse me probably I've been too generic ...

The real problem,  I think, relies on the fact that the query that I have written is correctly executed by PowerQuery but not from OLE DB sql server connectiion...

The query is like:

SELECT *
into #B 

from A

The problem seems to be in the using of #temp table, because if i use the simple select it works!

Otherwise I get the error

(my traduction from italian 😞 )

"Data initialization failed.
Check database server or call the database administrator. Check the external database is available"