Forum Discussion

AvPowerBI's avatar
AvPowerBI
Post Patron
4 years ago
Solved

Dataflow does it require a Gateway - Cannot Refresh when used in Dataset

Hi,

 

I created a DataFlow, within that Dataflow it connects to an OnPrem SQL Server 2008 R2 (Gateway used for this) server which is a table that contains a list of Postcodes. I can refresh this manually on the Power BI service or have this on a schedule and there are no issues.

I then locally open a pbix file and create my data model, which consists of the Postcode DataFlow and tables from an Azure SQL Database. When running this locally everything refreshes but when I publish this to Power BI Service and try to refresh this it throws the below error which I believe has something to do with the DataFlow

 

 

 

Do you have to have certain permissions to use a DataFlow when creating a Dataset?

 

Thanks

 

 

Need Help

2 Replies

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    That error has nothing to do with the underlying Dataflow connection. Your Power BI dataset doesn't know the dataflow is using a gateway.

     

    What other sources are in that file? If it is just a dataflow and an Azure SQL, you shoudn't need a gateway, but the error indicates you are using a gateway, and one or more of the cloud datasources cannot be processed by the gateway.