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 !