Skip to main content
Microsoft Idea

Power BI

Needs Votes

get data from excel which is RMS encryption

Vote (3) Share
's profile image

on 31 Jul 2017 09:47:11

when I get data from excel which is RMS encryption ,for the account I signed in PBID have no authority to access the "RMS excel " ,I get an error:"External table is not in the expected format." . if I sign in an account which have authority to access the "RMS excel " file, I can get the data success .
So I have a request : when I do not have authority to get data from the "RMS excel " ,PBID should pop up a window to let me sign in the username and password which have this authority .thanks !