Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Querying Composite Models with Excel

I have a composite model dataset, with my inventory data using import mode and my sales data using direct query. In a conventional report I can create a visualisation on the sales & inventory data bu...
Need Help
StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
4 years ago

yes you can, chek:

- if the dataset model you trying to access have the build on in option avaible, conection for a excel can be denied on the model permits itselfs.

- the user that you are log on in the excel have access to the model, if you logging with a user that doesnt ahve licence or permit if wont refresh. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    StefanoGrimaldi thanks for the tip. I forgot to mention I'm an admin on the workspace (and I believe that grants me all rights on its dataset).  Am I missing something?