Forum Discussion
Super UserCan SSRS use a Power Bi dataset ?
I think the answer is no … but I am still go to ask …..
Is it possible to connect SSRS to a Power BI imported dataset. If so how?
Or please make any suggestions on how best to convert a Power BI imported dataset to a SSRS readable format.
My Power BI imported dataset is refreshed once a day and takes data from multiple sources and formats it nicely using complex M queries into a star schema with Dim tables, Fact tables and DAX measures. It seems a pity to replicate all that ETL and relationship functionality in SSIS if it is possible to reuse any items for SSRS.
Just to be clear …
* I am asking can SSRS reports be run on the data from a Power BI imported dataset.
* I am not asking I if Power BI can get data from a SSRS.
Many thanks,
5 Replies
- amitchandak
speedramps , I think you can connect with SSAS
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data
Assuming SSRS might have SSAS below it? then you should be able to use
speedrampsThank you Ammit but I did say ....
* I am asking can SSRS reports be run on the data from a Power BI imported dataset.
* I am not asking I if Power BI can get data from a SSRS.
I think you have inadveretetly sent me instructions on how to get data from SSAS into Power BI.
Whereas I want to do it the other way round.
How can I tke the Power BI imported dataset and dump it into SSAS?
Many thanks,
- Don_Alexis
Helper I
Hello, I am taking a similar project get the data from various sources store them sql pass it to Power bi, a whole logic using AUTOMATE, you want this flow can help you or manage to create a new flow based :
Add row in SQL Server when an alert is triggered in Power BI and send email
Best regards.
