Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Best Way to Import Big Data from SSAS Cube?

Does anyone know the best way to import data with tens of millions of rows from SSAS cubes? Using one of the cubes in a SSAS server, I am looking to create a view with 8 columns and likely between 30...
Need Help
CracktheCode85's avatar
CracktheCode85
Icon for Helper II rankHelper II
1 year ago
Recreate the report in Power BI which has a gateway established for automatic refreshing. Essentially automate the report in Power BI. I don't suppose I could automate a Pivot from Excel to refresh a BI Dashboard could I? (with cube data?)
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
Recreate the report in Power BI

That's called "Fighting the API". Power BI is not Excel. Trying to make Power BI behave like Excel is an exercise in futility.   Use whatever tool is right for the job, but use it as it was meant to be used.

  • CracktheCode85's avatar
    CracktheCode85
    Icon for Helper II rankHelper II
    1 year ago

    I completely agree with you 🙂 

    I'd just like to be able to have some nice visuals that auto refresh from the source and tell a much better visual story 🙂 
    Unfortunately (as I'm learning with Cube data sources) this is not possible 😕 
    But I will keep our conversation in my back pocket for when I get asked why it's not possible 🙂