Forum Discussion
Using an Excel Workbook protected by Information Rights Management
Hi Corey-Flinders ,
AFAIK, current power bi not works on encrypted data sources. Please use normal version excel file to instead.
Regards,
Xiaoxin Sheng
Hi Corey-Flinders ,
According to your description, I think this should more related to sharepoint. I'd like to suggest you post this to sharepoint related forum to get better support.
Regards,
Xiaoxin Sheng
Hi Anonymous,
I'd argue that this isn't a Sharepoint problem. From what I can see, Sharepoint is working as expected. The Information Rights Management (IRM) permissions are applied to the workbook correctly, and PowerBI successfully retrieves the Microsoft Excel file.
The issue appears to be that Power BI can't open and read from a Microsoft Excel file that is protected by IRM. As the error I see is about a corrupt file. The file isn't corrupt though as it can be succesfully opened in Power BI.
To rephrase my original question then:
Does Power BI support using Microsoft Excel Workbook files that are protected by IRM. If so, how can use these files with Power BI as at the moment I get an error.
With thanks.
-Corey
Hi Corey-Flinders ,
AFAIK, current power bi not works on encrypted data sources. Please use normal version excel file to instead.
Regards,
Xiaoxin Sheng