Forum Discussion
DATA ISN'T FOUND
I am new to data flows and recently created one with like 10 tables. I then went on to create a data lake where I removed the set automatic featur off. I then went in and went into the data modeling and created the relationships. Although before I could pull the data from data flow now I can't. And when I try to pull from the microsoft fabric data lake option on power bi desktop nothing populates. I do see the lake house I created and select it but nothing gets pulled. I was wondering if I ruined it by doing the dat modeling? I also was wondering if I need to set up a pipeline to refresh the lake. If you could forward a good resource that would be helpful. Many videos I found are missing steps. The goal is to start using data flows and is it necessary to use a data lake or can I just do It all with the data flow but then how do you do the data moideling just from data flows if you don't create the data lake?
Hi Anonymous ,
Use Dataflow Gen2 to get the data then do the data cleansing transformation on Power Query Online and finally write it to Lakehouse by setting Destination.
When I Connect Lakehouse directly in Power BI Desktop I am also unable to find my data as shown in the screenshot below.
The solution is to select the “Connect to SQL endpoint” option and then choose to connect to the data in Import or Direct Query mode.
At this point you can see it works fine.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
2 Replies
Hi Anonymous ,
Use Dataflow Gen2 to get the data then do the data cleansing transformation on Power Query Online and finally write it to Lakehouse by setting Destination.
When I Connect Lakehouse directly in Power BI Desktop I am also unable to find my data as shown in the screenshot below.
The solution is to select the “Connect to SQL endpoint” option and then choose to connect to the data in Import or Direct Query mode.
At this point you can see it works fine.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!I tried that but it was not working. I went back into my data flow changed all tables to enable staging and now it works but I have to select connect if I want to grab it from my data flow. Everything is transfering over to the lake house I think
I also wanted to ask I have been trying to get the data lake DATE table month to be in chronological order. I tried creating a custom If statement and it's organizing it if I pull the dataflow data from get data but if I get the data thru the data lake I see the columns I added but the sorting is not working. I wanted to ask if it would be okay for me to just start pull the get data from the data flow instead of the data lake since I am having such a huge issue with this. The company will be pulling the data the way I recommend and I want to recommend the best path.