Expanded table in Power Query does not show in datamodel

[peikba2]

This used to work in previous versions in Power BI.

Any Idea how I can make it work?

[peikba2]

Hi Gao,

Been there done that 😀

I'm running on the latest version .

I have been clicking the refresh button so much, it is all warn now.

I would like to know if there is anywhere I can see how it transports from Power Query to Model Data.

/Peik

[v-cgao-msft]

Hi @peikba2 ,

What's the error message?
Try recreating a file and repeating the steps.

Best Regards,
Gao
Community Support Team

[peikba2]

Hi Gao,

Thanks for replieng.

 I have tried it many times, there are no error message, it just only shows the two records from the first table.

/Peik

[v-cgao-msft]

Hi @peikba2 ,

What is the data source? Is it possible to provide all the steps? I will try to reproduce the behavior.🤔

It would be nice to have a simplified test file that does not contain private data.

How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

[peikba2]

Hi Gao,

The data source is standard OData Feed from a Dynamics 365 Business Central 

[v-cgao-msft]

Hi @peikba2 ,

Generally, after clicking the Apply and Close buttons, a loading prompt will pop up on the desktop. But it doesn't seem to be in the photo above. 

1. Try clicking the Refresh button.

2. Try updating PBI Desktop to the latest version.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum