topic Re: Using Power BI Service Dataset in Report Server in Report Server

Using Power BI Service Dataset in Report Server

mdex — Thu, 30 Jan 2020 09:53:27 GMT

I'm not sure if this is a gateway configuration issue or due to the fact we're running an old version.

I started using Power BI Desktop (December 2019) to learn and create a few datasets/reports. A pro license was purchased to allow me to publish to Power BI Service. I've since found out we have an on premesis development report server running May 2019. I have the Power BI Desktop RS from May 2019 also. I used Desktop RS to connect to the PBI Service Dataset and rebuilt my report.

When saving this to our PBI Report Server and opening the report I get the error

'We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.'

I've gone into the manage option of the report and tried forcing my network login details again but the connection still fails?

Re: Using Power BI Service Dataset in Report Server

d_gosbell — Thu, 30 Jan 2020 21:44:27 GMT

Unfortunately this is the expected behaviour because shared datasets on PowerBI.com are not a supported data source for Power BI Report Server. And you can't even currently share datasets on the Report Server itself either. The only solution for sharing data sets in an on-premise scenario is to use SQL Server Analysis Services to create and deploy a tabular model, then you can create multiple pbix reports connected in Live Connection mode against those models. Otherwise you have to import the data into your pbix file and use a local model in your report.

Re: Using Power BI Service Dataset in Report Server

Mark_Haggett — Fri, 31 Jan 2020 12:07:16 GMT

Never tried it before with previous versions, but yesterday we installed January 2020 RS and you can connect to the Service and your datasets. Did a very quick test and it seemed to work ok.

Re: Using Power BI Service Dataset in Report Server

mdex — Fri, 31 Jan 2020 13:56:48 GMT

Thansk both.

I have the PowerBI.com dataset linked linked with Desktop RS. The issue occurs when I publish the Desktop RS report to our on premesis report server and try and view the data. It's as though there is an issue connecting to the PowerBI.com dataset from our On premesis report server as it works fine in Desktop RS.

Re: Using Power BI Service Dataset in Report Server

d_gosbell — Fri, 31 Jan 2020 21:08:46 GMT

If you check here https://docs.microsoft.com/en-us/power-bi/report-server/data-sources the Power BI Service is still listed as unsupported for Power BI Report Server.