cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChiliGuy
Frequent Visitor

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 wanted to edit that SQL (to add or remove a column or add additional filtering logic) I would go to “Edit Query” in Power Query Editor and simply copy and paste my updated SQL into that box.

ChiliGuy_0-1607012433676.png

 

This has worked flawlessly up until now. Yesterday, I updated my PBI Desktop to the November update, and I’m noticing new behavior. Now, when I go into the Power Query Editor and click the gear icon for “Source”:

ChiliGuy_1-1607012433678.png

 

First, instead of seeing the actual data (columns and rows) in the canvas, I now see a list of the schemas in my Oracle database:

 

ChiliGuy_0-1607012691219.png

And when the settings pane opens, “Advance options” is closed by default:

ChiliGuy_1-1607012715677.png

 

And when I open it, there is no SQL being displayed in the SQL Statement box:

ChiliGuy_2-1607012715678.png

 

Why is this happening? Is this a new “feature” with the November update? Does this have anything to do with setting the option for Formula > Enable M Intellisense…”??

 

Please help… this could become a major update issue for all the data models I’ve built over the years!!

 

6 REPLIES 6
WV
Regular Visitor

I am having the same issue!!!! I had it with Oracle SQL data base and with Azure Synapse. I am not able to find any real resolutions!

I am working in a report from my desktop and I have 23 queries - working in the tool as normal. I save and publish. When I go in the next day - ???? - just like that, ALL the queries are GONE. The size went from 840mb to 12kb. I was able to download the file I published and start working again from that but super scary.

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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?

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 ticketsubmit a support ticket


Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@ChiliGuy , see if there are some known issue on the issue page - https://community.powerbi.com/t5/Issues/idb-p/Issues

 



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

I have checked the Issues page and have found no reports similar to mine, at least not recently.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.