Forum Discussion

bee_kissme's avatar
bee_kissme
Regular Visitor
9 years ago

From MS SQL Server to Visual Studio to Power BI, right?

I import excel file to MS SQL Server 2016 already. I want to show report in Power BI but the project must use OLAP cube technology also. I am not sure in my step working   Step 1: Import Excel file...
BetterCallFrank's avatar
BetterCallFrank
Resolver IV
9 years ago

hi bee_kissme

I see :-)

of course, if part of the exercise is to create a multidim olap cube, then go ahead and do so.

however, you can very well model a clean star schema in a tabular model within powerbi, which is like "the new version of olap cubes" - maybe your teacher does not know that - but its up to you, whether you want to challenge him on that ;-)

Have fun building your cube :-)

 

Frank

bee_kissme's avatar
bee_kissme
Regular Visitor
9 years ago

Hi BetterCallFrank


You prefer Power BI is the new version olap cubes, right? If I create star schema good, it is not necessary to do olap cube in Visual Studio Business Intelligence?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi bee_kissme,

     

    >>If I create star schema good, it is not necessary to do olap cube in Visual Studio Business Intelligence?

     

    I find a function to directly export excel file to cube, perhaps you can refer to below blog:

    How to create cube files for offline use using Excel

     

    Regards,

    Xiaoxin Sheng