Forum Discussion

DawnSP's avatar
DawnSP
New Member
2 years ago
Solved

Analysis Services Connection Questions

Hi I work for a midsize company that began using PowerBI in January 2023. We have a 'live connection' to our datacube via SQL Server Analysis Services. The live connection disables all the modelin...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Power BI has an Analysis Services connector.  When you are using the live connection, you are using the SSAS model as your reports model.  Thus you are having your edit issue.

    Alternatively, you can connect to your SSAS model via import and download data into your own model.  Power BI runs on SSAS tech, so you can rebuild the model in Power BI.  SSAS isn't great for transferring large blocks of data but you could do a mix where you grab the summarised outputs from SSAS but get your large transacational data from the original sources.

     

    One note, when you do an import connection to SSAS it will treat it like a cube.  So make sure to make in dividual connections to individual tables if thats what you were trying.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI has an Analysis Services connector.  When you are using the live connection, you are using the SSAS model as your reports model.  Thus you are having your edit issue.

Alternatively, you can connect to your SSAS model via import and download data into your own model.  Power BI runs on SSAS tech, so you can rebuild the model in Power BI.  SSAS isn't great for transferring large blocks of data but you could do a mix where you grab the summarised outputs from SSAS but get your large transacational data from the original sources.

 

One note, when you do an import connection to SSAS it will treat it like a cube.  So make sure to make in dividual connections to individual tables if thats what you were trying.