Forum Discussion

abelrmg's avatar
abelrmg
Icon for Helper II rankHelper II
6 years ago

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 ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

Currently this can be done and should work, can you make sure you have got the latest version of the Gateway installed?
abelrmg's avatar
abelrmg
Icon for Helper II rankHelper II
6 years ago

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,

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    What happens when you say it does not work?

    If you can give an example and possible screenshot please.
    • abelrmg's avatar
      abelrmg
      Icon for Helper II rankHelper II
      6 years ago

      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,

       

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        6 years ago
        Could it be that the data source you are using is not supported for DirectQuery?