The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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,