Forum Discussion

ashleylinkewich's avatar
ashleylinkewich
Advocate II
6 years ago

PBI Running Batch File When I Edit Query

Hi all,   I have a CSV that is an output from a microsoft batch file. There is no query between them, the batch file simply outputs the CSV.   When I connect to this in PBI desktop, it will initi...
Need Help
ashleylinkewich's avatar
ashleylinkewich
Advocate II
6 years ago

Hi parry2k, thanks for your response.

 

My question is: "How do I query the data so it doesn't run the windows batch file?" 

 

The structure of my flow is this: Windows Batch File ---> Output CSV <---- PBI Reading the CSV 

 

Currently, despite having no connection between the CSV and windows batch file, it still runs and gives me an authentication error, whereas I would expect it to query the CSV like any other. 

 

Does this clear it up? 

 

 

parry2k's avatar
parry2k
Super User
6 years ago

ashleylinkewich not at all, where you get the authentication error, Power BI has nothing to do with Batch file until I'm missing something here.

  • ashleylinkewich's avatar
    ashleylinkewich
    Advocate II
    6 years ago

    parry2k  This is the error I get: 

     I agree, PBI should have nothing to do with the file, and it acts normally when I first establish the connection to the output CSV, but as soon as I modify the query and apply the changes, I get this error. 

     

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      6 years ago

      Hi , ashleylinkewich 

      Is it related to the modifications you made to the query?

      If you still have this issue  you can create a support ticket in Power BI Support to get further help.

       

      Best Regards,Community Support Team _ Eason
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.