cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nigel_Mayhew
Helper III
Helper III

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

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!

1 ACCEPTED SOLUTION
Geradav
Responsive Resident
Responsive Resident

@Nigel_Mayhew 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

View solution in original post

3 REPLIES 3
Geradav
Responsive Resident
Responsive Resident

@Nigel_Mayhew 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

View solution in original post

Nigel_Mayhew
Helper III
Helper III

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
Super User IV
Super User IV

@Nigel_Mayhew , 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.