Forum Discussion
Using Power BI Service Dataset in Report Server
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....
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.