Forum Discussion
Solved
Cannot read from the table in power query when connected as DirectQuery for Power BI datasets
Hi All, I have a problem. 1) I connected using DirectQuery for Power BI datasets, as described here https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure...
Sounds like you need to request that a Dataflow is created that has the table(s)/queries from Dataset A. That way, you can do downstream transformations, if needed.
Pat
Thank you! I've chosen the solution with data flow, because I can use power query (M language) There. Your solution is DAX based. Maybe it would help me in some other case. Thank you for you help.
AlexisOlson
Super User
Super UserJust to be clear, it's a DAX query within an M language query. As I mentioned, you don't necessarily write any more DAX than EVALUATE and a table name.