Live Connection doesn't retrieve the Measure folders

[mmace1]

In our golden dataset, I have things organized into folders: 

If I do a live connection to our golden dataset, on a brand new PBIX file - the folders come through. Awesome. 

If I do a live connection to our golden dataset, using a file that already has some work done in it however - the folders do not flow through.  Everything is just completely disorganized, with no folders

The big problem, is we have a template file to build new reports - and apparently that file counts as a "has had some work done in it", because even though I deleted out the data tables prior to The Live Connection - the measure folders don't flow through from the golden dataset. 

How can I force those folders to come in over the Live Connection? 

[parry2k]

@mmace1 I will test but I don't think moving measure in a different folder should have an impact if best practice is followed that measure never be used with table name like 'My Measure Table'[Measure] since measures are global to the model, using it without table name is the way to go. 

Anyhow, I'm curious to do the test, will check it later today.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@mmace1 it is weird that for existing reports the folders will not show up. I have to test it but since you already did at your end, I guess you probably need to report it as a bug but I will surely test at my end sometime soon and will get back with my findings.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[mmace1 · Accepted solution]

@parry2k 

Got it.

Composite models don't bring over the metadata. So composite model = no folders from the golden dataset will appear in the model. 

e.g. - start with a fresh file - live connection - folders are there.  Add a single import table - it becomes a Composite Model (in which the Live Connection becomse Direct Query), and you lose all your folders. 

And - my template file - though I'd deleted all the tables, still had a single query that wasn't visible until I went over to Power Query. Thus it was being forced into Composite Models, and the folders from the golden dataset weren't showing up.  Remove that, and I can use the template file > leave things in Live Connection Mode > see the folders in the dataset.  At least until I inevitably bring in a table via import. 

Just the moment I import a table, we'll go to Composite mode, and those folders will be lost. 

[mmace1]

@parry2k 

I'd love for you to test, just in case there's some "I'm crazy" thing I'm not noticing.  

I *think* I can see the logic - if one makes a live connection, maybe then they want to introduce new folders / change the folders.  It could be messy if those folders from the data model, then end up overwriting. 

I feel like the ideal-behavior would be that on a live connetion, one just can't change the folders.  But apparently that's not how it's setup.