topic Re: using excel data as direct query in Desktop

using excel data as direct query

HadiRajani — Fri, 09 Jun 2017 05:39:46 GMT

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

Re: using excel data as direct query

Anonymous — Fri, 09 Jun 2017 05:48:13 GMT

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:

Re: using excel data as direct query

v-ljerr-msft — Tue, 13 Jun 2017 06:45:55 GMT

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. :smileyhappy:

Regards

Re: using excel data as direct query

HadiRajani — Thu, 12 Oct 2017 13:06:40 GMT

Thanks for your response

Re: using excel data as direct query

MarcelBeug — Thu, 12 Oct 2017 13:18:02 GMT

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?

Re: using excel data as direct query

v-ljerr-msft — Fri, 13 Oct 2017 01:53:12 GMT

Hi MarcelBeug,

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

Regards