Forum Discussion
Refresh data
Hello I have a report with different sources: 1. Azure SQL, Direct query 2. SQL database, import mode 3. Sharepoint folder, import mode 4.Local file Excel, import mode I configured a gateway ...
Hi there
Currently this can be done and should work, can you make sure you have got the latest version of the Gateway installed?
Currently this can be done and should work, can you make sure you have got the latest version of the Gateway installed?
Hi GilbertQ , all data sets in import mode works, but if I publish the report with mixed mode, import and direct query mode don´t works.
My question is focused if it is possible to publish report with mixed mode, import and direct query, like this:
Azure SQL server, direct query
SQL Server Database, import
Sharepoint folder, import
Local file Excel, import
Regards,
- Hi there
What happens when you say it does not work?
If you can give an example and possible screenshot please.Hi GilbertQ , ther error is displayed when open the report: "Data source unreachable" and if you try assign a gateway show this error: "Failed to use the selected gateway. Please make sure the gateway is up and running and try again".
But if you convert all datasets in import mode the same gateway works fine.
Regards,
- Could it be that the data source you are using is not supported for DirectQuery?