Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there any possibility to use excel data as direct query in power bi ?
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
As per this link:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
The following data sources are currently supported:
Thanks for your response
@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?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |