Forum Discussion

April's avatar
April
Regular Visitor
5 years ago
Solved

File structure change while adding table in power query editor

Hi, 

 

I was trying to add a table in the Power Query Editor within a dataset which already contains a file structure. However once I added the table within a specific folder, saved, closed and reopen the dataset again, the file structure is gone and every table has an "?". Can you please help to explain what went wrong? 

 

Thanks. 

Need Help
  • edhans's avatar
    edhans
    5 years ago
    April wrote:

    Hi, 

     

    I was trying to add a table in the Power Query Editor within a dataset which already contains a file structure. However once I added the table within a specific folder, saved, closed and reopen the dataset again, the file structure is gone and every table has an "?". Can you please help to explain what went wrong? 

     

    Thanks. 

    It may be related to this issue where the groups are removed. That is not a file structure, just grouping folders. Microsoft does have a repro, but they have not answered back that the cause has been identified or that a fix is in progress.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    need more details - is that in Power BI desktop or on the service?

  • edhans's avatar
    edhans
    Community Champion
    5 years ago
    April wrote:

    Hi, 

     

    I was trying to add a table in the Power Query Editor within a dataset which already contains a file structure. However once I added the table within a specific folder, saved, closed and reopen the dataset again, the file structure is gone and every table has an "?". Can you please help to explain what went wrong? 

     

    Thanks. 

    It may be related to this issue where the groups are removed. That is not a file structure, just grouping folders. Microsoft does have a repro, but they have not answered back that the cause has been identified or that a fix is in progress.