Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Live Connection doesn't retrieve the Measure folders

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...
Need Help
  • mmace1's avatar
    mmace1
    5 years ago

    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. 



parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

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's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
5 years ago

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.