Created report on PBI Desktop....cannot publish it on Report Server

[Anonymous]

Hello all,

I created a report on the PBI Desktop Dec 20, then opened it and edited it on the PBI Desktop (optimised for Report Server) Oct 20. I get an error message every time I open it on PBI Desktop (optimised for Report Server), saying:

"Unable to open document...the queries were authored with a newer version of Power BI Desktop and might not work with your version....please install the latest version to avoid errors when refreshing"

I proceed regardless. The report opens, and I'm able to refresh the data and edit the report without any issues.

Now, my problem is that I'm not able to publish the report to our PBI Report Server. I tried it directly from the report, and also from the webpage of the Report Server.

Is there a simple way to recreate the report again on the PBI Desktop (optimised for Report Server), so I can then publish it on our Report Server?

Looking forward to your help!

[Geradav · Accepted solution]

@Anonymous I guess the simplest way will be to copy the M code and paste it to a new Power BI Report optimized for Report Server.

Same for all DAX measures and reconstructing the data model.

Good luck!

David

[Anonymous]

Thank you @amitchandak.

The report is complex with lots of mergers and measures, and it would be a pain to have to recreate it all again. 

I hope someone else will come up with a solution.

[amitchandak]

@Anonymous , I doubt an option for that. If these are visuals. You can try copy paste from one pbix(dec-2020) to another(Oct-2020)  .

You have to use power bi optimized for report server in this case.