Forum Discussion
Gracie
8 years agoHelper II
Schedule Refresh Failed For Reports containing GA data and SQL Server Data
I have a report containing data from Google Analytics and SQl Server Database. When I schedule refresh, it has below error. I tried setting privacy level for all data sources to be public and...
- 8 years ago
v-qiuyu-msft This is the right file path to do the fast combine. https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-personal-mode/
v-qiuyu-msft
8 years agoCommunity Support
Hi Gracie,
1. Please refresh the report in Power BI desktop to see if the same issue occurs.
2. In your scenario, you should use on-premise data gateway (personal mode) for the dataset to refresh, please turn on Fast Combine follow this article: Disable privacy setting in Power BI Gateway - Personal.
Best Regards,
Qiuyun Yu
Gracie
8 years agoHelper II
v-qiuyu-msft This is the right file path to do the fast combine. https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-personal-mode/