Power bi connect to dataflow gen2

Hi Aomran since you have permissions and access have you enabled remote connections for your SQL Server? If not, open SQL Server Configuration Manager and go to SQL Server Network Configuration. Navigate to Protocols for your SQL Instance, right-click on TCP/IP, and select Enable. Restart the SQL Server service to apply the changes. Let me know if this resolves the issue!

Hi Akash_Varuna ,

Thanks for your reply. I'm talking about dataflow gen2, can you please give more dierction how I can enalbe the remote connection for SQL server? I'm still new with Fabric.

Aomran Let me make sure I understood your setup. You have DF Gen2 and you are sending the output of this dataflow to a fabric data warehouse or Lakehouse? Is this a correct understanding?

Let me tell you what's excatly I'm doing!

My understadning is, no need to store the data before consume it by power bi desktop, right?

So, I have dataflow gen2 without publish the data to anywhere! Just ingest the data from the source system and save the dataflow! In the power bi desktop, I've got the above error when trying to load data from dataflow!

Please let me know if it's not option to load data from dataflow without store it in lakehouse or wharehouse!

Thanks

Aomran although if you don't send the output of dataflow to lakehouse/warehouse, it still stores the processed data. Best practice with df gen2 is to store the output to a lh/wh but if you are not storing it into the lh/wh, you can still connect to the dataflow and should be able to get the data from df gen2. Once you are connected to df, you should see the tables instead of SQL server. What dataflow connector are you using?

Thanks for your clarficaition, I'm not storing the data because no need for that, and to minimize the cost!

So in theory, I should be able to consum data from df gen2, but I've got the above error!

The connector is dataflows in power bi desktop, I've tried the first and last one!

Aomran I generally used non-legacy, and as you can see, I navigated to my workspace -> then dataflow 3 -> and as I expanded it I saw tables that are part of this dataflow. Not sure why things are different at your end.

Hi Aomran ,
Just wanted to check if you had the opportunity to review the information provided by parry2k  and Akash_Varuna ?
If the response/s has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Hi v-sdhruv,

No there is no solution for this yet!!! I had to use dataflow gen1 to make it work with power bi! I would be apreacited if you can find a solution for this issue!

Thanks