Forum Discussion
Issue in uploading PBIX to Report Server
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 !
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.