Forum Discussion
Composite Model Publishing after Dec 2020. SSAS + Excel Sheet
Hi AlexD43 ,
If I understand correctly, you have stored the excel file that was originally stored in on premises in SharePoint location, right? Have you updated the connection method of excel file (from connect to Excel to connect to Sharepoint) in the report? You can refer to the solution in the following threads to solve your problem.
SharePoint List Access to resource is forbidden
n:Expression.Error: Access to the resource is forbidden. (SharePoint & Unpivot)
Best Regards
I've tried both and changed the connection type.
I think we have some funky permissions in our company-managed 365
rules preventing us giving open access; our PBI accounts are separately arranged as most employees don't need it.
I've actually arranged for the data to be copied into the PBIx file as a manual table which is now working, but ideally moving it to Excel at some point to allow someone else to update the table would be better so this is still relevant learning for me; just slightly lower priority as I've published what I needed to with a different method.