Forum Discussion

Stefan_S's avatar
Stefan_S
Regular Visitor
8 years ago
Solved

Using getway with Datasets witch have one excel query

Hello,

 

I have used my getway for a SQL-Query (CRM) succesful to update a Dataset.

Now I have add a local Excel-Sheet to this Dataset. (I don´t won´t Update this excel-sheet).

After I upload this Dataset to the Power BI Service, the connection to the getway faild.

I´m aware I can´t update the Excel, but the update of the SQL-Query also failed.

How I can set the Excel-Querry to "no update", so the getway will work for the SQL-querry again.

 

Thanks for your support.

Stefan

Need Help

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Stefan_S,

    In Power BI Service, it doesn't support to refresh specific data source in a single dataset. And when you combine multiple data sources in a single dataset, all the data sources should be added within gateway in order to refresh the dataset.

    Have you added the excel data source within gateway? Could you please post the full error message?

    Regards,
    Lydia

    • Stefan_S's avatar
      Stefan_S
      Regular Visitor
      8 years ago

      Hello Lydia,

       

      thanks for your answer. Orginal the excel was local on HDD and there is no getway on my PC. Now I have try to use the Excel-sheet in 365 (Sharepoint). But when I change the Source-Setting in Powerdesk to the Share-point-Link, the system said, i have noch access.

      But I have, i tried the link in the browser. There i have Access.

       

      The errore message:

      "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway. "

      I have still access to the company gateway, and it still work on other datesets with the same SQL-sources.

       

      Thanks

      Stefan

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Stefan_S,

        Based on your description, you combine on-premises SQL data source and SharePoint Online Excel data source in a single dataset, right? If  so, you would need to use on-premises gateway(personal gateway) to refresh your dataset.

        Regards,
        Lydia