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

Alignement between Power BI Service and Power BI Report Server

Hi all,

 

i've published some reports on the Power BI service (with Power BI Desktop July 2020 update) and i need to publish them also to our Power BI Report Server.

 

When i try to open the .pbix file with Power BI Desktop for Report Server i got the error message that the file is incompatible with the version of Power BI Desktop: i think that's because the latest version for Report Server is September 2019, right?

 

Own can i publish those .pbix files to our Report Server without rebuild them?

 

Thanks.

Francesco

9 REPLIES 9
FrancescoSCP
Helper III
Helper III

My mistake, i've updated to Power BI Desktop for Report Server May 2020.

 

Now when i open a .pbix file i got this error message:

PowerBI_ReportServer.png

 

Regards,

Franceso

Hi @FrancescoSCP ,

yes thats because you enabled the metadata format in the previous features. Thats acutal not supported in Power BI Report Server. You can build this report again in the fitting desktop for RS - copy and paste all visuals - that should be easy - If you havn't that much measures. 🙂

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Hi Kathrin,

 

thanks for the reply!

With your suggestion i have also to rebuild the data model right? Is there a document that lists the limitations of Power BI Report Server againt the online service?

 

I've tried also to open an older document but i've recived the error that many to many relationship is not supported....

 

Regards,
Francesco

@FrancescoSCP 

you can open your pbix with non-RS pbi Desktop then disable parameter "store datasets using enhanced metadata format" save file and it should be reopened with RS version (maybe with some warning message)

It is a fundamental option that need for future Power BI development and it has no available (for wide range of users, of course) list of limitations


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Hi @az38 ,

tested this scenario two weeks ago, in my case this doesn't work. 

 

Best,

Kathrin 

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

@KBO 

in my case it has worked ok as I remember 🤔


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Hi @az38 ,

Let's say in case your solution doesn't work he can try my solution ;).

Two solutions are  better than one!

 

Best, Kathrin 

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

@KBO 

it's not a solution battle 🙂

I learn here, you learn here and topic-starter learns here 🙂

if we will be able to help anyone - it doesn't matter what exactly solution works


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Hi @FrancescoSCP ,

I don't think that there is a detailed documentation about thoose differences because the cloud changed monthly and that would be to much effort.

The relationship issue can be solved: delet all relationships in the former version and open it in the RS again :).

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Kudoed Authors