Forum Discussion
Cannot read from the table in power query when connected as DirectQuery for Power BI datasets
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 for the reply. I'm trying to achieve the following configuration
1) Dataset A is published to Power BI service and connected to the database via on-premise gateway. It is kind of core dataset.
2) There are several teams who create their own datasets (Team 1 dataset, Team 2 dataset , etc.) using data from Dataset A . These teams may want to place additional logic ,like join tables create grouping tables, calculated attributes in power query
It's not a DirectQuery, but it is possible to load tables (or whatever DAX query on Dataset A you like) by connecting to it in the query editor as an Analysis Services Database. Then you can do whatever you'd like with it.
See my post here for an example of such a query:
https://community.powerbi.com/t5/Service/How-can-I-set-up-a-scheduled-refresh-for-tables-that-are-DAX/m-p/1661546
(If you just want a plain table from the model, then the DAX query is simply "EVALUATE TableName".)
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.
Just 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.