The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi!
I'm having a report that gets data from a SharePoint list. Everything is working fine when using my own account.
But when changing to another service account (read permissions on the SharePoint site) and refresh the model, it's missing one column (the one I need).
I have tried to logon directly to SharePoint with the service account, and I can see all columns in the list.
Why is the column disappearing when using the service account?
/Jonas
Hi,
Even though the service account has read permissions, ensure that it has the necessary permissions for all relevant content types and hidden lists that might be associated with the column in question.
Proud to be a Super User! | |
But if I login with the service account in SharePoint, I can see all columns, but when fetching the data from Power BI a single column is missing. So I don't think this is a permission issue.
Is it a List? because you would be able to expand the columns, could it be hidden under those column?
Proud to be a Super User! | |
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |