Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Direct Query (Analysis Services) connection to corporate gateway issue

Hi,
 
I have created pbi report with live connection to existing data source. Additionally, I had to add another source from sharepoint, this is why Power BI automatically converted my report to DirectQuery connection (Analysis Services). I got these 2 messages below while creating report, which i accepted:
 
After publishing on the web, I wanted to schedule refreshing, which requires connection to the company's gateway. Analysis Services accept only Windows authentication, so i entered all the essential, corporate credentials. Such message popped up in this step:
 

 

 

Any ideas how to get through this?

 

General Comment
Need Help

4 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , Anonymous 

    For your questions, here are my answers:

    (1)When you connect to a dataset in Power BI Desktop , the connection mode is "Live Connection". In this mode ,we cannot connect other datasources .When we try to connect other datasource, it attempts to convert Live Connection to DirectQuery mode.And using the DirectQuery for Power BI datasets and Analysis Services feature will present you with a security warning dialog, shown in the following image.(This is  your first two screenshots )

    For more information, you can refer to this document:

    Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn

     

    (2)When you republish a new composite data model, it generates a new dataset. The linkage may like this:

    When we want to refresh the second dataset, we can see that the dataset is associated with the first dataset(it just like a cloud data source), so we only need to configure the credentials for the first dataset in "Data Source Credential" (We need to have build permissions for the first dataset).

    We can click "Edit credential" and choose "OAuth2" and then login our Power BI account.

     

    If the second dataset is connected to another data source, we need to add data source credentials for the data source as appropriate.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks v-yueyunzh-msft for your response.

     

    I do not have trouble with adding import data source to the gateway. The problem occurs when I try to connect Power BI data source (report which i based on) to the corporate gateway. I cannot schedule refresh due to this source. 

     

    Changing this data source credentials in PBI desktop, results in new message in power bi online, when trying to add source to gateway with Analysis Services by Windows authentication.

    "on-premises data gateway's service account failed to impersonate the user"

     

    Best Regards

     

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi , Anonymous 

      If your data source is the dataset in Power BI Service, you don't need to add the data source credential in the gateway , you just need to configure the credential of the dataset in "Data Source Credemtial":

      Then we choose "OAuth2" and use our AAD account to login in the data source.

       

      Best Regards,

      Aniya Zhang

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, v-yueyunzh-msft 

     

    When I try to do it as suggested, then this pops out:

     

     

    I have used in Power BI desktop one of the existing data sources from Data Hub:

     

    I believe it has to be connected to the corporate's gateway to schedule refresh for selected data source.

     

    Take care,