Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

DennesTorres

Model and Default Dataset are not synchronized in a lakehouse

Submitted by Impactful Individual on ‎08-07-2023 11:09 AM

Hi,

The image below shows the tables in my lakehouse. They are from a Microsoft tutorial.

DennesTorres_0-1691431205333.png


Two of the tables (dimension_employee and dimension_stock_item) contain a binary field (a picture) and are not accepted as part of the default dataset. As a result, the synchronization with the default dataset stopped on them and fact_sale is not included as well.

The button "Manage default Power BI Dataset" shows this:

DennesTorres_1-1691431382434.png

 

However, on the Model tab of a SQL Endpoint, it's possible to see all the tables available, even the ones which are not included in the default dataset. 

DennesTorres_2-1691431488616.png


This seems to be a bug, I believe the Model tab should be synchronized with the default dataset, otherwise we will get strange errors if we try to use modeling features over tables which are not present in the default dataset.

To test this, I tried to create a relationship between customer and sales table, one is in the dataset and the other is not. The result was a strange error message, complaining about the photo field in the stock_item table.

The error message is a problem as well. A relationship between customer and sales complains about stock. It's weird.

DennesTorres_3-1691431692400.png


Kind Regards,

Dennes

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎08-09-2023 01:00 AM

Hi  @DennesTorres 

I don't really understand your question. Do you mean that you have 6 tables in your lakehouse, but when you call lakehouse, only 3 tables are selected? And then when the data is loaded, you see the data for 6 tables again?

 

Best Regards,
Community Support Team _ Ailsa Tao

DennesTorres
Impactful Individual
Impactful Individual
‎08-09-2023 05:51 AM

Hi,

No. When I mention "Model Tab",  I'm not talking about Power BI Desktop. I'm talking about the "Model Tab" inside the lakehouse SQL Endpoint. Everything on the portal.

This tab shows all the tables, even when the tables are not included in the default dataset. As a result, attempts to create relationship between tables not in the dataset fails very badly.

Kind Regards,

 

Dennes

Idea Statuses