Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
REP85
Frequent Visitor

Drill through cross reports

Hello,

I have a double question. I'm wondering if it is possible in Power Bi, the following scenaro is possible !

 

Drill Through between 2 pages of the 

 

1- Create a report based an SSAS cube on one page and a detailed report from the same DW but based on SQL server

or

2- Create 2 differenr reports, one based on SSAS cube (whatever if it's an OLAP or TABULAR cube) and another totally different report based on SQL Server and the perform a Drill Through from the SSAS report to the SQL server report.

 

Thanks in advance for any answer.

 

2 ACCEPTED SOLUTIONS
TomMartens
Super User
Super User

Hi @REP85 ,

answer to question (1)
at the present time, this is not supported due to the fact that real-time connections (SSAS Tabular (on-premises or in Azure) or SSAS multidimensional are not supported in composite models. MSFT has already announced support for Power BI and Azure Analysis Services data models in composite models, then this will be possible. Here's the link to the current Power BI roadmap: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/composi...

However, I have no idea if local Tabular SSAS will be supported as the feature evolves. I doubt that SSAS Multidimensional is supported at all.

answer to question (2)

perhaps you can adapt the solution described in this article by @paul_turley: https://sqlserverbi.blog/2019/07/04/drillthrough-from-power-bi-to-an-ssrs-paginated-report/



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

@REP85 , It is about linking SSAS Tabluar, Not sure to adapt to your requirements https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data. I think for other things @TomMartens has already given the answer

View solution in original post

4 REPLIES 4
TomMartens
Super User
Super User

Hi @REP85 ,

answer to question (1)
at the present time, this is not supported due to the fact that real-time connections (SSAS Tabular (on-premises or in Azure) or SSAS multidimensional are not supported in composite models. MSFT has already announced support for Power BI and Azure Analysis Services data models in composite models, then this will be possible. Here's the link to the current Power BI roadmap: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/composi...

However, I have no idea if local Tabular SSAS will be supported as the feature evolves. I doubt that SSAS Multidimensional is supported at all.

answer to question (2)

perhaps you can adapt the solution described in this article by @paul_turley: https://sqlserverbi.blog/2019/07/04/drillthrough-from-power-bi-to-an-ssrs-paginated-report/



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi Tom,

 

Many thanks for your quick reply. The solution looks great. We are goint to test it rapidely.

 

BR

@REP85 , It is about linking SSAS Tabluar, Not sure to adapt to your requirements https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data. I think for other things @TomMartens has already given the answer

Hi Amitchandak

Many thanks for your reply, I'm going to look at the article

BR

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.