Forum Discussion

Mohammed-'s avatar
Mohammed-
Resolver I
2 years ago
Solved

Missing Columns in Dataflow Gen2

Hi 1- I created warehouse and then dataflow to get data from sql server and the destination target was created automatically in the bottom right of the page as in the attached photo below   ...
Dataflows
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    Hi Mohammed- 

     

    Following up to see if the above answer was helpful. And, if you have any further query do let us know.

Mohammed-'s avatar
Mohammed-
Resolver I
2 years ago

Very sorry for delay, Thanks for your replay  it is very helpfull to me

I have onther queries there is any way to work in pipelie through sql queries  as i did in datafllow gen 2

i mean there is such options like Advanced option in the connection

thre reason i need that option i am testing fabric i with  big sql databae it is JD Edwards database aboun 4000 tables and tons off columns i need to get data form some table and sum column  i dont knoow my query ,some thing like the photo

 

I allrady create  a simple data set from  my sql database, create connection to sql server then data follow gen 2 and  warehouse , then connected the warhouse to power bi desktop to create some time intelligence report  ans i i ok   i will try to make it as document and send it you just to hear from you yor comments if you this allow to me

any way sorry for delay again and thank you very very much

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi Mohammed- 

     

    Thank you for using Microsoft Fabric Community.

    Glad to know that your issue got resolved.

     

    Thanks for asking your query . The ask here is different from the original ask. Can you please start a new post with your ask as it would be helpful for others?

    Thanks for understanding.