PBI Running Batch File When I Edit Query

[ashleylinkewich]

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 initially give me no problems and refreshes fine, like any other CSV would. However sometimes, once I've made edits to the query and try to apply them, PBI attempts to run the batch file and I get an authorisation error. 

Has anybody ever come across this or understand why PBI is running a batch file it, theoretically, should have no connection to? Or how to change a setting so it only reads the CSV file?

Thanks, 

[parry2k]

@ashleylinkewich sorry but your question is not at all clear. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[ashleylinkewich]

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]

@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]

@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]

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.