Creating a Dataset from a Lakehouse/SQL Endpoint

[Ashwath_Bala_S]

Hi,

I need to create a Dataset from my existing data available (On a short note, my tables are present as shortcut tables).
I would like to get 3 tables out of that, to generate a auto-create report on that.
Any assitance on this will be highly helpful.

Thanks in Advance

[govindarajan_d]

For every lakehouse, there will be a auto-created semantic model. You can create report, by clicking on its settings and selecting auto-create report option. 

For creating custom Semantic model,  go to the lakehouse view, on the top there will be option to create new Semantic model. One of the major difference is you can edit the custom semantic model with XMLA endpoint. 

[Ashwath_Bala_S]

Hi, 

I have tried this method previously, but facing the issue of not able to select any particular tables.

On a short Note, My tables are from FnO to Dataverse to Fabric (as Shortcut Tables.)
Any assistance on this will be helpful, to create customer semantic model and creating a automated report.
Thanks in Advance

[govindarajan_d]

Are they in delta format? If not then they cannot be added to semantic model. 

[Ashwath_Bala_S]

Hi,

The tables are present in Delta Format, but they are as shortcuts, as they are from other environment. Tables are present in this manner.

Is there any way to work on this to create a auto-created report using Semantic Model. If not, kindly let me know what can be the reason, since Fabric is a fresh perspective.

Thanks in Advance

[govindarajan_d]

Can you try using this refresh icon when you create semantic model? I think it should come after this.

[Ashwath_Bala_S]

Hi,

I have tried refreshing, but not still able to see any tables

Is being as shortcut tables inside Fabric a reason.

If we cannot create a auto-create report using this, kindly assist what can be the reason and is there any alternative for this to create an Auto-Create Report.

My requirement is to shortlist tables and then choose specific columns for the report.
Kindly assist.

Thanks in Advance

[Ashwath_Bala_S]

Hi,

Is there any other possible solution for this, to create an auto-report in my case.

My flow of data is from Dataverse to Fabric (as shortcut Tables).

I need to extract only specified tables and moreover some specific columns.

Kindly assist

[frithjof_v]

This worked for me when I tried this some months ago.

Dataverse -> Shortcut (Dataverse Link to Fabric) -> Lakehouse -> Semantic Model -> Report

Not sure why it isn't working in your case. I would raise a support ticket.

[Ashwath_Bala_S]

Hi,

How about creating a Auto-Report will all the available tables and then manually filtering out.
I have tried that, but it was not as effective as creating using particular tables.
Will the prior one be effective, over the later one?
Kindly assist.
Thanks in Advance

[frithjof_v · Accepted solution]

Personally, I have not used the Auto-Report. I tried it a couple of times, but I still prefer to build the report from scratch. Maybe this will change in the future, as I'm sure the technology will develop further. But for now, I am building my reports from scratch.

Sometimes I use a company template report as a starting point for the layout.

Either copy+paste visual elements from the template report into my new blank report.

Or make a file copy of the template report file, and connect it to the semantic model, and then continue developing the report.

[v-cboorla-msft]

Hi @Ashwath_Bala_S 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[Ashwath_Bala_S]

Yeah, it helps.

Thanks

[v-cboorla-msft]

Hi @Ashwath_Bala_S 

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.