Forum Discussion

Jankwi_onl's avatar
Jankwi_onl
Frequent Visitor
6 years ago
Solved

Dataflow returns only blank values using a on-premise SQL server with enterprise gateway

Hi all, When I create a dataflow with a SQL server as datasource and a gateway, I do get records in the Power Query window while creating the dataflow.  When I save and refresh the dataflow ...
Dataflow
Need Help
  • Jankwi_onl's avatar
    Jankwi_onl
    6 years ago

    Well, after a couple of tries, I just thought.... Let's use another browser than Microsoft Edge....

    And guess! Problem disappeared while using Chrome!

    I did exact the same in Edge as in Chrome. Edge did behave exactly the same, no errors or exeptions. But somehow Edge does something with in the query window which causes the issue that data is not stored correct in PowerBI Service.

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Jankwi_onl ，

 

I‘ve checked many docs but unfortunately I cant find the reason,so pls try to clear your data source then reenter it:

If it doesnt work ,you'd better propose a support ticket.

 

https://powerbi.microsoft.com/en-us/support/

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

 

Jankwi_onl's avatar
Jankwi_onl
Frequent Visitor
6 years ago

Well, after a couple of tries, I just thought.... Let's use another browser than Microsoft Edge....

And guess! Problem disappeared while using Chrome!

I did exact the same in Edge as in Chrome. Edge did behave exactly the same, no errors or exeptions. But somehow Edge does something with in the query window which causes the issue that data is not stored correct in PowerBI Service.