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
KBO
Super User I
Super User I

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!

az38
Super User II
Super User II

@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
KBO
Super User I
Super User I

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!

az38
Super User II
Super User II

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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!