Forum Discussion

jpquinn's avatar
jpquinn
Helper I
9 years ago
Solved

Design Question - Upload File, to merge/use w/ Existing PBI Report Built from Cube

Hello, I have drafted out an elaborate SSIS and SSAS plan to pick up a flat file, load and integrate into a cube, so a report can be enhanced with a users certain account numbers to associate with t...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    jpquinn You mention cube, so I assume the Power BI Report is using Live Connection, if that is the case, then "no", you can't import data and have a live connection to the cube. The connection type must remain the same and is a singular connection when connected to SSAS.

     

    If the user is importing from the cube (don't see the relevance of this) then yes the user could have a seperate data source and create a relationship between objects in the Power BI file, or merge/manipulate in whatever way needed.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jpquinn You mention cube, so I assume the Power BI Report is using Live Connection, if that is the case, then "no", you can't import data and have a live connection to the cube. The connection type must remain the same and is a singular connection when connected to SSAS.

 

If the user is importing from the cube (don't see the relevance of this) then yes the user could have a seperate data source and create a relationship between objects in the Power BI file, or merge/manipulate in whatever way needed.

jpquinn's avatar
jpquinn
Helper I
9 years ago

Thanks for this fast feedback. Yes, it would be Live Connection. So I guess I'm stuck going through with the original plan of SSIS/SSAS route and set it more in concrete.