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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Live connection to fabric not working

I have a lakehouse and a seperate warehouse set up with test data.
Online I can use the explorer to see the data and I can open the warehouse and see data. I can also use the sql endpoint of the lakehouse and see the data in SQL management studio.
But I can't see any data when I use the live connection in powerBI desktop to the datalake or the warehouse.
Question is why can't I see any data?
Also when online, if I go to the default created sematic model and select explore this data (preview), the data part keeps on loading but no data is shown. See screenshots.
(Online, If I create a new semantic model, I can add the data and build a report on it. But I cannot download this semanticmodel and open it in powerBI desktop.)

Logged in correctly and have admin access. Tried with a second account. Same issue. 
(We do still have P1 as a licence?)

IF I pulblish an empty report with the lakehouse connection set up and then open the report I get this error message:
Underlying Error: Capacity operation failed with error code CannotRetrieveModelException
Activity ID: 299a2503-4c89-48d1-9197-91b15d6a7bda
Correlation ID: c99af012-b3cf-c07e-f764-1be58ca2cfbe
Request ID: a595db85-f5d3-87f7-f9b2-42190a5e7128
Time: Fri Mar 01 2024 10:30:51 GMT+0100 (Midden-Europese standaardtijd)

Service version: 13.0.22729.77
Client version: 2402.3.18145-train
Cluster URI: https://wabi-west-europe-d-primary-redirect.analysis.windows.net/ 
fabric3.pngfabric2.pngfabric1.png

Status: Investigating

Hi all 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

 

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
LodeBisschops
New Member

In case anyone is still wondering how to resolve this. 
The issue lies with the default semantic model, which was not created by default in my case. 

To resolve this, go back in your lakehouse through the sql endpoint. Then press on the "manage default semantic model" button and select the tables you want to be included. 

press confirm and the default semantic model works as expected! 

LodeBisschops_0-1712522097950.png

 

jeroen_guns
Frequent Visitor

Thanks! That did the trick.

Vogels
Frequent Visitor

@LodeBisschops Thanks for the tip! This indeed fixes the problem. 

Microsoft confirmed this is not a bug, but the new way of working as of now. 

Pawansingh
Regular Visitor

 

Yes, updating the semantic model will enable to use the tables in the Lakehouse to be used in PowerBI.

1. Select Workspace

2. Click Lakehouse name

Pawansingh_1-1716144050687.png

3. Select "SQL Endpoint" from right hand side corner dropdown

Pawansingh_2-1716144128928.png

4. Click on "Reporting" tab

Pawansingh_3-1716144166754.png

5. Click "Manage default Semantic Model". Add the tables in Semantic model and save

Pawansingh_0-1716143923680.png

6. Use the "Lakehouse" option in "OneLake data hub" to establish the connection with lakehouse in Fabric worspace

Pawansingh_4-1716144396611.png

 

good luck !!