Forum Discussion

NancySharma's avatar
NancySharma
Regular Visitor
8 years ago

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 ...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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. 

NancySharma's avatar
NancySharma
Regular Visitor
8 years ago

It does not work when i move Power BI File  from one user to another. am i doing something wrong?

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi NancySharma

     

    I'm not sure what you mean by "moving from one user to another"

    • NancySharma's avatar
      NancySharma
      Regular Visitor
      8 years ago

      so once i ma able to join the databases and able to design the report the way i want. i save it as Microsoft Power BI Desktop Template (.pbit) and send the same to other users. But wen they open is template and try to run the report by refreshing it does not work.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        NancySharma,

        What error message do your users get?  Could you please also post the codes in your Advanced Editor? Do mask sensitive data before uploading codes.

        Regards,
        Lydia