Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
gampy
Advocate I
Advocate I

DataFlow behavior change

Hi everybody,

Нas anyone recently noticed a strange transformation in the DataFlow behavior when querying SQL DB?

Up to the last week the following construction worked perfectly:

SQL = "SELECT * FROM [dbo]. [Table]",

Source = Sql.Database (Server, DB, [Query = SQL])

 

Now, on saving a query in dataflow, the latter transforms the query to:

Source = Sql.Database(Server, DB), that is removes [Query = SQL]).

 

The following request created using the interface (or manually) still works:

Source = Sql.Database(Server, DB, [Query = "SELECT * FROM [dbo].[Table]"]) 

 

The first scenario still works on the Desktop…

 

I have a huge number of queries written according to the first pattern. I'm puzzled what to do with all this legacy now.

1 ACCEPTED SOLUTION

It seems they fixed it 🙂

View solution in original post

2 REPLIES 2
gtacchini
Advocate I
Advocate I

Same issue here and it's a HUGE deal!!!

 

1) I had several dataflows that used SQL native queries up and running until friday

2) I received a refresh error, when I open a dataflow, those queries now have removed the native part and are just showing the tables available in the database

3) Only 2 out of my 3 dataflows have this error. 

4) I had my dataflow jsons saved and they worked, now if I create a new dataflow I have the same issue

 

Help please!! All of our reports are now broken. im desperate!

It seems they fixed it 🙂

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors