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 ...
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 🙂

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

As you can see, my dataset contains a dataflow and a local file. After I configure the gateway for the local file, it can be refreshed normally.

So this problem is not caused by the dataflow, but by other data sources in the dataset. Please check whether the gateways of other data sources are configured correctly or whether there is an error in the data source. 


Once I deleted the local file in this dataset by mistake, a problem like yours happened.

 

 

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 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 🙂