Forum Discussion
Can't refresh data after appending queries which are from different data source kinds
Anonymous
Anonymous
Hi, did you get your report to work at Power BI service - that is - get the automatic refresh working?
I have a similiar problem: I have a PBI workbook with SQL Server and documentDB data and I have appended a new query from these two data sources.
The automatic refresh was not completed and gives me an error indicating that the Appended Query table was the root of the problem (CRM_ERP_total_sales).
Any idea how to fix this? I am combining old sales data from SQL Server and combining it with the new sales data from Azure DocumentDB.
edit: I am using for this case the new Gateway in Personal mode and I have defined the data sources in Edit Credentials. I had to install this GW in Personal mode just for this report, because our existing On-premises GW did not function with both on-premises SQL server data and cloud data (Azure DocumentDB).
edit2: I could swear this worked yesterday when I tried to refresh the data in Power BI service On demand (it refreshed the data, there's 8 second difference what the dashboard tile refresh time shows and Refresh History), but now when I look the refresh history it says all of them failed, for the same reason
The work around solution for the moment is to list the file in your gateway. So rather than place the Folder in your gateway, you will need to list the exact files. Its awful but it works. It is what we are having to do until this issue is properally corrected.
Anonymous
Okay, thanks for the tip. Do you mean I have to add some exact file paths in the Power BI Gateway (Personal) application on the server machine which I have installed it? Do you know what is the name of executable file on the actual file drive? I feel like a dummy trying to find the actual new Power BI personal gateway files, since the file gateway paths & folder etc. are not very explicit IMHO
Or do I have to define the exact DocumentDB colletions in Power BI Service as above (app.powerbi.com)? Now I have in a way just the root URL of our DocumentDB cloud database.Hi Anonymous
I'm not sure how you would do it with the Personal Gateway, but the bug I am talking about affects the On-Premise Data Gateway and you add these into your "Manage Gateways" section within the Power BI Service.
I have a similar issue. However, in my case, I have only a single data source, my redshift db. The issue occurs while going for schedule refresh using on-premise gateway(personal mode). I am able to publish it from Power BI Desktop, but unable to schedule it from power bi online.
It was mentioned in one of the troubleshooting docs of on-premise data gateway that you might have to install a data provider in the same system where the gateway is installed. But that too is not working. I have already got the 64 bit ODBC driver for Amazon Redshift installed in my machine. It still doesn't work.
