Forum Discussion
Issue in uploading PBIX to Report Server
Hello,d_gosbell ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hi,Anonymous . I am glad to help you.
It looks like you are having problems uploading pbix files to Power BI Report Server.
Here are my suggestions which I hope will be helpful to you
1. report server supports backward compatibility.
A .pbix file created by a newer version of Power BI Desktop may not open on an older version of Report Server. On the contrary, .pbix files created with older versions of Power BI Desktop can usually be opened on newer versions of Report Server.
Therefore, you need to ensure that the version of Desktop (RS version) and report server used to create the report are consistent (new features added in newer versions of Desktop are not available in older versions of Report Server Web Protal, resulting in file upload failures)
2. check whether Report Server can access the data source used by the pbix file (set the data source credentials for the report correctly in web protal)
3. you mentioned storage in SharePoint. does this mean that the data source used by the pbix file is a sharepoint folder (On- premises)
Or does it mean that you want to store a pbix file stored in a sharepoint folder in Report Server (the data source used by the report is another database).
In either case, make sure you have sufficient permissions to upload files on Report Server and that the data source credentials are set correctly (authentication way).
URL:
Power BI report data sources in 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.
Hi Carson, thanks for your valuable suggestions made reg the issue.
Regarding the data source issue, I feel the same that the data source is in our org environment's SharePoint folder and while the Report Server is in client's organization. Could that be creating an issue that the Report Server is not able to access our environment's SharePoint ? What could be the possible solutions to it ?
Thanks in anticipation. Merry Christmas and Happy Holidays in advance !!!