Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Generic Error Message - Report Server

  Hi,   Need help to understand more about an error message that I receive when opening a file on Power BI Optimized version, I make sure that I do not use the Import Query, no Order-by, no CTE or...
error message
Need Help
KBO's avatar
KBO
Memorable Member
6 years ago

Hi Anonymous ,

have you checked the relationships? In the RS Version is no Many-to-Many possible ;).

 

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     Hello KBO ,

     

    Sorry, I forgot to mention there are no Many-to-Many relationships on the Data model as I create reports for the report server and need live data, Yes I did make sure that there are no Many-to-Many relationships or Composite relationships on the reports. 

    • KBO's avatar
      KBO
      Memorable Member
      6 years ago

      HI Anonymous ,

      in wich version of the Desktop Client (Cloud) you've build the report? May be the differences between the clients are to big? Otherwise connect the source again in Power BI Desktop Client for Report Server and copy and paste the visuals/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!

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi KBO ,

         

        I had built all my reports on Power BI July 2019 Desktop version and later moved them to the Power BI (Optimized - Sept 2019) version to put it up on the report server site, I managed to successfully migrate few reports, but there are few which have CTE's on the query and some have these generic error messages,

         

        Then I did try creating new RS version reports for the ones which I could not migrate and copy-pasted the visuals to the new RS version reports, but still keep getting the error.