Forum Discussion
How to connect to Power BI dataset
I want to build a paginated report which uses a dataset created in Power BI desktop. We do not have Power BI Premium, only Report Server. Is it possible for me to host this dataset somewhere where the paginated report can connect to it?
You cannot connect to Power BI Datasets hosted on Power BI Report Server. But what you can do on-prem is to re-create the dataset as an Analysis Service Tabular model, then you can connect your paginated report to that (plus you can connect Power BI to the same data set using a live connection and publish those reports to Power BI Report Server)
5 Replies
- d_gosbell
Super User
You cannot connect to Power BI Datasets hosted on Power BI Report Server. But what you can do on-prem is to re-create the dataset as an Analysis Service Tabular model, then you can connect your paginated report to that (plus you can connect Power BI to the same data set using a live connection and publish those reports to Power BI Report Server)
d_gosbell are you able to implement user defined parameters in the Analysis Services Tabular data model to be used with the paginated report?
- d_gosbell
Anonymous wrote:
d_gosbell are you able to implement user defined parameters in the Analysis Services Tabular data model to be used with the paginated report?
It depends what you mean by "user defined parameters", if you talking about the "What if" parameters in Power BI Desktop then these just generate a calculated table of numbers and you could copy the table expression from Power BI and paste it into a SSAS model.