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
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.