Forum Discussion
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-analysis-services
2) Clicked make change and add local model
After that I can create dashboards using the data.
However, when I try to create a new power query and read the data from one of the existing tables I get the following error.
(I want to write a new query to join and combine several tables)
Is there any other way to read data from tables connected via DirectQuery ?
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
7 Replies
You can't pull tables into Power Query from your data model. The flow of data goes the other way.
Data Sources --> Power Query --> Data Model --> Measures and VisualsYou're still connected to that table though and can use it for building visuals.
What is the goal you're trying to achieve by attempting this?
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
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
