Forum Discussion

Smokey24's avatar
Smokey24
Helper I
6 years ago
Solved

Import/Manipulate data from Analysis Services / Data Cube

Hi all,   I hope I post this in the right category. I have a problem which I need your help with.   We have stored data in several cubes and I want to build reports based on the data of the cube...
Need Help
Tips and Tricks
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Smokey24 ,

    Yes. If you connect to AS with live connection, it means that no data from the tabular model is imported into Power BI Desktop. We get data and relationships from AS directly. You could view the data that is available in AS.

     

    For more details, suggest you to take a good look at the document:Connect to Analysis Services tabular data in Power BI Desktop .

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Smokey24's avatar
Smokey24
Helper I
6 years ago
Different idea. Since I’m loading out of a cube there should be already an internal data model. There are measures and the dimensions.

So if I load the measures in on table and the dimensions in a separate table I would have a fact table with the measures and dim tables.

My question is, if I do load it this way are the tables connected? Meaning I would have a sum in the fact table i.e. 1000000 and the stores in a dim table.
Is it then still possible to to say see which store sold how much? So I would have a list of stores and their respective sales?
  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Smokey24 ,

    Yes. If you connect to AS with live connection, it means that no data from the tabular model is imported into Power BI Desktop. We get data and relationships from AS directly. You could view the data that is available in AS.

     

    For more details, suggest you to take a good look at the document:Connect to Analysis Services tabular data in Power BI Desktop .

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    i am facing the same issue, with huge data in the cube. did you find any solution, can you please help if you find solution ? my question is also same, if i import table separately and then create model in power bi level will it work ?