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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.