Forum Discussion

tlanza's avatar
tlanza
Advocate I
7 years ago

Cannot add a dataflow to a gateway

I created a dataflow using a blank query and I was able to run it showing the data, and save it correctly. It's important to note that I select my on-prem gateway at this creation step. However, when...
Dataflow
dax's avatar
dax
Community Support
7 years ago

Hi tlanza,

I test this in my environment, I use below query in blank query(I choose gateway before)

let
    Source = Sql.Databases("server\instance"),
    newsql = Source{[Name="newsql"]}[Data],
    dbo_sorttime = newsql{[Schema="dbo",Item="sorttime"]}[Data]
in
    dbo_sorttime

It will show me this option when I click "Next"

Then after I type credential and finish this, the dataflow works well  in my environment. You could try to set this in applied steps(edit queries->source) in your dataflow to see whether it works or not.

In addition, which type datasoure did you used in dataflow, could you please inform me in details?

Best Regards,
Zoe Zhi

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

 

tlanza's avatar
tlanza
Advocate I
7 years ago

Hi Zoe Zhi,

I assume I would have to add that test sql  database to my gateway as a connection right? 

For my dataflow, I'm not trying to connect to a sql database. I'm trying to use a Web connection to make an API call to my system. I typically do all of my configurations to my data in Power BI desktop > copy the M code from the query > paste it as a blank query in the dataflow creation on the web. This has worked perfectly for me in the past with no issues. Now, over the past few weeks I've been running into these issues that prevent me from creating or adding to my existing dataflows. The dataflows I created months ago still work fine but I'm unable to make new ones. I should also add that only new dataflows I create do not allow me to edit the gateway information for them. All of the existing dataflows allow me to change the gateway information.

 

I'm hoping someone has a fix or this is a known issue becuase I shouldn't have to backdoor basic functionality.