Forum Discussion

AdamWidi's avatar
AdamWidi
Frequent Visitor
7 years ago

Power BI Dataflows fails to refresh to On-Premesis SQL Server through Data Gateway

I have built a dataflow that connects to an on-prem SQL Server through the data gateway.  The designer works fine and I can build the dataflow, however the refresh fails with the following message.  ...
Dataflow
Need Help
GilbertQ's avatar
GilbertQ
Super User
7 years ago
Hi there

Does your account have multi factor authentication enabled?
AdamWidi's avatar
AdamWidi
Frequent Visitor
7 years ago

No, we do not have multi factor authentication enabled at the moment.

 

Thanks, Adam

  • THEG72's avatar
    THEG72
    Helper V
    7 years ago

    Hi AdamWidi ,

     

    Having the same issue too with On-Premise data source... Works fine with Dataset refreshing on demand and scheduled..

     

    When building the data flow query online the gateway refreshes fine.. it's just once the query is saved, the refresh doesn't work on demand or scheduled.

     

    I have tried with both MFA on and MFA off.


    The query i am using grabs an on premise API data source which is using a Json function and Web contents function to return the table data.

     

    I did notice the run time date in the CSV log states "invalid date"? anyway logged with MS for now.