Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,mitapate .Thank you for your reply.

In fact, I think the main reason for your problem is that there is a big mismatch between the version of Power BI Desktop (RS version) and the version of Power BI Report Server Web Protal the user is using.

Please try to save the pbix file as the May 2024 version before publishing it to the client report server (it may be a problem to open and save the high version file with a low version of software.)
If you can save the pbix file successfully, please upload the May version of the pbix file to Web Protal, which is also the May version.

URL:
Download Microsoft Power BI Report Server - May 2024 from Official Microsoft Download Center
 

If the above way will be an error because pbix can not save as a lower version of the file. You need to update your client's Power bi Report Server (in line with the Desktop version), and take care to save important report files to avoid incompatible file versions.
Generally speaking, the official version download link will only be saved for the last one year, so you need to update the version according to the actual situation, and save some historical version download files (if necessary, you need to restore the version).

URL:
Change log for Power BI Report Server - Power BI | Microsoft Learn
 
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for your reply . I tried the same approach of making the version compatible but it is still giving the same issue hence leads me to thinking if the Many-to-many relationship between tables is causing the error or the data source permissions. 

 

Thanks !

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,Anonymous .Thank you for your reply.
    If you are thinking about data source connectivity issues and the pbix file data source you are currently experiencing issues with is indeed Sharepoint folder. hopefully my tests and documentation below will help you.
    You can try creating the pbix file using another data source (different from SharePoint folder) to test if the same issue occurs.

    select save as > Power BI Report Server

    When I click upload on the web portal it uploads fine.
    However, it should be noted that if you need to refresh the data using sharepoint as the data source on Power BI Report Server, this is not supported at the moment, and you can only implement cached refresh, i.e., after refreshing the data in Desktop (RS vsersion), and then uploading the updated pbix file s to the Report Server again, you can only do this by uploading the updated pbix file s to the Report Server. to the Report Server.
    Because Desktop connection sharepoint data source generally use Microsoft Account for authentication, and Power BI Report Server only supports Windows authentication, the better practice is to change the data source type, the sharepoint data source changed to the data source type supported by PBIRS.
    URL:

    Power BI Report Server with sharepoint Online dat... - Microsoft Fabric Community

    The Report Server only supports Windows authentication

    If there is any deviation in my understanding, please feel free to correct me and provide details (type of data source, validation method, whether I have right of access to the data source, etc.)
    I look forward to your reply.