Native Query is not working for Mail attachment as Data Source

[TamilselviK]

Hi All,

My Data source is a mail attachment - .txt file, I am using Native query to push this attachment data to SQL server. I can accomplish this when i run it from power bi desktop. Data are getting loaded into SQL server. I published this to Power BI Service though the schedule run says its completed but the data are not getting loaded into SQL server. 

I tried to create same in Power BI dataflows but here i'm receiving below error.

Regards,

Tamilselvi K

[v-janeyg-msft]

Hi, @TamilselviK 

The way you tried before should not support txt type. So why don't you directly import the txt file in powerbi? 

Reference:

Get Data from Text File to Power BI (tutorialgateway.org)

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[v-janeyg-msft]

Hi, @TamilselviK 

Can you share how you do it? Why not import it directly into powerbi?

I doubt that it doesn't support .txt files, usually the data source needs to support Query folding.

Reference:

Import data from a database using native database query | Microsoft Docs

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[TamilselviK]

I'm exporting data to SQL Server

[v-janeyg-msft]

Hi, @TamilselviK 

So what data source do you consider now and do you still have problems?

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If problem still persists, pls let me know.

Best Regards,

Community Support Team _ Janey

[TamilselviK]

I consider .txt file type and issue is not resolved

[GilbertQ]

Hi @TamilselviK 

Can you confirm that you have got the latest version of the On-Premise Gateway installed?

[TamilselviK]

I'm not using gateway.