topic How would I use my Power BI data model in paginated reports? in Report Server

How would I use my Power BI data model in paginated reports?

Anonymous — Wed, 15 Jul 2020 08:01:37 GMT

I have data from a SQL Server database. I would like to load it into Power BI and do my data modeling there and then use that model to build reports in report builder that I can upload to report server. There is no option to connect to a Power BI dataset from report server, but in report builder I have the option to connect to a Power BI workspace dataset. If I publish the dataset to my workspace and then connect to that dataset in report builder, would I then be able to use that model for a report that I upload to report server?

Re: How would I use my Power BI data model in paginated reports?

Anonymous — Wed, 15 Jul 2020 16:53:29 GMT

No, there is currently no support for building reports against a powerbi data model in report server. Also note that the feature to connect to a Powerbi DataSet is only available in Power Bi Report Builder, which is meant to be used with the service and will have incompatible features. With On-premises power bi report server you should use Microsoft Report Builder.

Thanks

-Boreki

Re: How would I use my Power BI data model in paginated reports?

saglamtimur — Thu, 16 Jul 2020 08:37:50 GMT

There is a workaround which I have never tested, and don't know if it's still valid. Have a look at this thread.

https://community.powerbi.com/t5/Report-Server/RDL-using-Power-BI-Dataset-in-Service/td-p/763273

If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍