Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community.
I am struggling to make work a report I have built.
It looks like data connections Credentials to Odata is now missing the scope drop down wich prevents me from setting credentials at a site collection level. as I am using a function to loop in all site collection sites, Power BI is asking for each sites whereas I would like to set credentials at only one level.
image here https://drive.google.com/open?id=0B7Q-yCcd-1dtcjE1RFRmX1JQNm8
while using SharePoint connection, the option is here : https://drive.google.com/open?id=0B7Q-yCcd-1dtbE5rNVg2WFdYZnc
can you help me with that?
thanks
Jerome
Hi @jejetator,
>>as I am using a function to loop in all site collection sites, Power BI is asking for each sites whereas I would like to set credentials at only one level.
I think it is impossible to use the only one level credentials and custom function loop all site. It will ask for the permission when loop to next level each time.
Regards,
Xiaoxin Sheng
Thanks Xiaoxin.
actually it was working in previous versions of PowerBI but it seems it has changed in the current ones.
I have bypassed the problem in using the Sharepoin.File function instead of the odata feed. with that data connection, the 1st time the credential is asked, I can enter the scope and then the other loops are using the same function.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |