Forum Discussion

Vucko's avatar
Vucko
Advocate II
6 years ago

Native database queries not working in Dataflows

Hi,   I am pulling some data from SQL server to dataflows. The queries use some prefiltering using SQL. Everything was working up until yesterday, but since then, when I try to pull data from this ...
Dataflow
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Vucko ,

 

I am afraid that Power BI service doesn't support it currently.

You could come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

 

Vucko's avatar
Vucko
Advocate II
6 years ago

This feature was working until last wednesday though. It was possible to allow native database queries inside dataflows.

The feature still work in the dataflows now - if I import such query it prompts me to enable native database queries. 

When pulling the dataflow into desktop report, it shows the dataflow "folder", but no queries indside. Same issue was reported by multiple users here already.