topic Feeding the same report with a new set of data on the PBI server in Report Server

Feeding the same report with a new set of data on the PBI server

Anonymous — Tue, 18 Feb 2020 10:15:12 GMT

Dear Community,

I have a .pbix file published to the server. The .pbix file is made in Power-BI desktop fed with MS Excel data, and uploaded to the server using REST APIs.

So far, everything went well and I see my report properly on the server.

Now, I want to update the same report but with a new dataset (the dataset is Excel and has the same columns and format).

Do you know how this replacement of the data manually and eventually with APIs is possible?

Thank you in advace,

Majid

Re: Feeding the same report with a new set of data on the PBI server

KBO — Fri, 21 Feb 2020 08:52:37 GMT

You can switch the datasource in the power query editor under source.

Or how do you connect the file in the Power BI Desktop?

Best,

Kathrin

Re: Feeding the same report with a new set of data on the PBI server

Anonymous — Mon, 24 Feb 2020 17:10:41 GMT

Yess, and even better to make a 'parameter' form the source and later manipulate it with API calls 🙂