Forum Discussion
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 check the "ignore the pricacy level and potentially improve performance". It doesn't help, still failed. I am wondreing why and asking for help.
Thanks.
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/
4 Replies
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 Yuv-qiuyu-msft Thanks for your reply. I cleaned my gateway and installed on premise gateway(personal mode) and then refreshed the dataset again. I got below error message.
And I looked the web page you sent. I can't find the file path. There's no connector file in my file. It's werid.
I don't know what the error message means?
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/
