Forum Discussion

peikba2's avatar
peikba2
New Member
3 years ago

Expanded table in Power Query does not show in datamodel

This used to work in previous versions in Power BI. Any Idea how I can make it work?  
Need Help
peikba2's avatar
peikba2
New Member
3 years ago

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi peikba2 ,

 

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

 

Best Regards,
Gao
Community Support Team

  • peikba2's avatar
    peikba2
    New Member
    3 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        peikba2
        New Member
        3 years ago

        Hi Gao,

         

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