Forum Discussion

kap_55's avatar
kap_55
Frequent Visitor
6 years ago

Can I use PBI Service dataset for PBI Report Server?

Hi,

 

So I have model in PBI which I use for multiple reports and I always connect to PBI Service dataset and create new report for PBI Service.

*The dataset uses cloud and on-premise data via PBI Gateway.

Can I use this dataset for PBI Report Server?

Open PBI for Report server, select dataset from PBI Service, create report, upload report to PBI Report Server.

I tried it and I am getting an error: We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.

Thanks.

K.

dataset connection

2 Replies

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    6 years ago

    I think this would only work if your dataset is on a premium capacity and you used the XMLA endpoint to connect. Otherwise you might just have to put your reports on the service too (since the dataset is already there anyway)

    • kap_55's avatar
      kap_55
      Frequent Visitor
      6 years ago

      What about dataflow? It's very similar so I guess not but is this also the case?