Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Migrate report from SSRS to powerBI

i HAVE MANY REPORT TO MIGRATE FROM SSRS TO POWER BI.

 

The reports to migrate are connected to multidimensionnel cube .

The new reports will be connected to tabular cube.

 

Is there any limitation to migrate from mdx to dax? to migrate ssrs to powerBI?

Need Help

1 Reply

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Based on my research, currently it is not supported to embed SSRS report into Power BI desktop. But you can pin a SQL Server Reporting Services (SSRS) report to Power BI Dashboards. For more details, please refer: Pinning a SQL Server Reporting Services Report to Power BI . Or you can upload your SSRS report to Power BI on-prem report server: https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-paginated-report 

     

    For the MDX and DX, These two different languages rely on different modeling concepts, because MDX has a semantic based on dimensions, attributes, hierarchies and measures, whereas DAX only knows table and columns. It may need to be convert based on paticular situation, some functions may be different to use between those two languages:


    Best regards,