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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
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
Advocate I

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 !!