using excel data as direct query

[HadiRajani]

Is there any possibility to use excel data as direct query in power bi ?

[v-ljerr-msft]

Hi @HadiRajani,

As @Anonymous mentioned above, using excel data as direct query in Power BI is not supported currently. You can add it as an idea on Power BI Ideas to improve Power BI on this feature. 

Regards

[Anonymous]

As per this link:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

Supported Data Sources

The following data sources are currently supported:

• SQL Server
• Azure SQL Database
• Azure SQL Data Warehouse
• SAP HANA
• Oracle Database
• Teradata Database
• Amazon Redshift (Preview)
• Impala (Preview)
• Snowflake (Preview)

[HadiRajani]

Thanks for your response

[MarcelBeug]

@v-ljerr-msft to my understanding, Direct Query requires some DataBase Management System at the data source.

So how do you think Excel would accommodate this? Otherwise you wouldn't suggest to raise an idea, or would you?

Or am I missing something?

[v-ljerr-msft]

Hi @MarcelBeug,

Thanks for pointing me out! I think you're definitely right. Learnt a lot. 

Regards