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
Microsoft EmployeeSounds 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
That worked for me. Thank you!