Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Dataflow -- Error when adding to gateway

Hi

I have a power Bi dataflow that is working correctly ( It is connected to 2 excel files in sharepoint).

No issues with refreshes, I can setup auto refresh and any manual refresh also works with the dataflow.

 

I have one report that is connected to multiple sources including this dataflow (Teradata/Excel/Dataflow).

This report I can't setup gateway refreshes because of this error message:

Extension {"extensionDataSourceKind":"PowerBI","ExtensionDataSourcePath":"PowerBI"}

 

I tried creating a new dataflow to see if somehow the original one was corrupted but I got the same error message using a test powerbi report only connected to the dataflow.

 

Any ideas or recommendations?

 
 
 

Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Lionel.

    I figured out last friday what was the issue.

    The gateway is managed by IT, and they didn't have the checkbox to allow cloud sources selected, that is why I couldn't refresh or schedulle.

    After they selected the checkbox the problem was solved.

    I don't have access to that configuration so I couldn't figure out myself.

     

    Thanks for all the help 🙂

     

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Lionel,

      Thanks, I tried recreating before posting the question here and had no luck.

      Also tried loading with the "include in refresh" disabled.

       

      any other ideas?

       

      Thanks 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    As tested, this problem does exist. When dataflow is used as a data source, we cannot configure a gateway for it.

    This should be normal, because when dataflow is used as a data source, we don't need to configure a gateway for it. And after testing, I found that it can be refreshed successfully.

     

    Best regards,
    Lionel Chen

    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
      6 years ago

      Hi v-lionel-msft 

       

      The dataflow I have no problems refreshing but the report using the dataflow as a source cannot be refreshed.

      When trying to map to the gateway I can't click apply to map the other sources and because of that  I cannot schedule a refresh( see image below), even manual refreshes don't run, see the error mesage below.

      If this is a know issue how can I request a fix for it?

       

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        1. We really can not configure the gateway for dataflow in the dataset, and there is no need to configure it.

        2. If you have installed the standard version of the gateway, there is no need to install a personal version of the gateway.

        Types of gateways 

        That is, these two tips will not affect your refresh operation.

         

        “...but the report using the dataflow as a source cannot be refreshed.”

        So I feel very strange that you cannot refresh the dataset containing dataflow. Could you show your refresh history and refresh errors?

         

        Best regards,
        Lionel Chen

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