Forum Discussion
Power BI Data Service v Desktop Refresh
I find the PBI Service very frustrating with the privacy levels stuff. I had previously always set to ignore, until I learnt that you cannot refresh datasets in the service without having privacy lev...
Don't use Web.Contents for your Sharepoint based data sources. Use SharePoint.Files instead. The main idea is to keep the maintenance effort low and connect as high up in the folder tree as possible (essentially at the site level).
Yes, you need to keep your computations in the same Power Query partition. No way around that.
Privacy levels have their purpose. Only ignore them if you don't care about your data leaking.