Forum Discussion
Way to query data using SQL and csv file
I want to query my sql database based on some fields in csv file. When i connect to query can i use the query to connect this way for example. SELECT Column1 ,Column2 ,Column3 ...
Hi NancySharma
It shouldn't stop. Power Query should be smart enough to know that it needs to fully load the CSV table to generate the list you need for your SQL data source. If you click the view dependances button on the PQ ribbon you should see a diagram showing the flow of the logic.
I think something else might be causing an issue.
It does not work when i move Power BI File from one user to another