Forum Discussion

ChiliGuy's avatar
ChiliGuy
Frequent Visitor
5 years ago

Mysterious Disappearing SQL Statement in Get Data > Import

I have been consistently using “Import” and pasting SQL into the “SQL statement” box in “Advanced Options” in order to filter the rows and columns getting pulled into my data model. To date, if I wan...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ChiliGuy,

Any changes on your data connector that you applied? Any previous feature you need on your report? Please share more detailed operations steps to help us clarify these. 

How to Get Your Question Answered Quickly 

In addition, I'd like to suggest you enter the 'advanced editor'(view ->advanced editor ) to check the whole power query formula to confirm if these additional SQL statements are stored in the data connector steps optional parameters.

Regards,

Xiaoxin Sheng

ChiliGuy's avatar
ChiliGuy
Frequent Visitor
5 years ago

The Gateway is updated whenever an update is made available. The October update was completed and there hasn't been an update released since then. Since I just noticed this last week, I suppose the October (or an earlier) update could have been a cause, but I fail to understand how any changes in the Gateway (which is local) would remove the SQL from a PBIX's Import object (which is in the Service). Can you explain how the two might be related?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi ChiliGuy,

    I also not so sure about this, maybe they do some optimate on the data connector encode or interface/ports, and these options parameters not compatible with the old version gateway or blocked by your device settings.

    Have you configured the whitelist of power bi service requests? 

    Add Power BI URLs to your allow list 

    In addition, you can also consider submitting a ticket to ask the power bi team to trace these if the issue related to the backend processing.

    submit a support ticket


    Regards,

    Xiaoxin Sheng