Hello everyone,
In order to extract Data from SQL i have been using Queries. However, now i want to extract from a specific Database that is so large that it will never "refresh."
My solution was to use a connection instead of a query.
in the power query editor, i had this string in the header:
= Sql.Database("...", "...", [Query="select * from ... where ... like '%...' and ... like '...'"])
In order to extract the data i wanted, i had this string in my excel sheets:
=IF(B2="","",VLOOKUP(B2,Query1[[...]:[...]],13,FALSE))
Basically, i want to use the same process with a connection instead of a query so that i do not need to refresh anything but excel extracts the data directly if i enter a value into Field B2.
in the power query editor, my string looks like this:
= Source{[Schema="...",Item="..."]}[Data]
The Table of results that i get in the query editor is exactly the same.
Now i dont know how i should edit my string in cells so that i get the same results. If I use this string:
=IF(B2="","",VLOOKUP(B2,Connection1[[...]:[...]],13,FALSE)) where Connection1 is the name of the connection, I get an error message.
In order to extract Data from SQL i have been using Queries. However, now i want to extract from a specific Database that is so large that it will never "refresh."
My solution was to use a connection instead of a query.
in the power query editor, i had this string in the header:
= Sql.Database("...", "...", [Query="select * from ... where ... like '%...' and ... like '...'"])
In order to extract the data i wanted, i had this string in my excel sheets:
=IF(B2="","",VLOOKUP(B2,Query1[[...]:[...]],13,FALSE))
Basically, i want to use the same process with a connection instead of a query so that i do not need to refresh anything but excel extracts the data directly if i enter a value into Field B2.
in the power query editor, my string looks like this:
= Source{[Schema="...",Item="..."]}[Data]
The Table of results that i get in the query editor is exactly the same.
Now i dont know how i should edit my string in cells so that i get the same results. If I use this string:
=IF(B2="","",VLOOKUP(B2,Connection1[[...]:[...]],13,FALSE)) where Connection1 is the name of the connection, I get an error message.