https://community.fabric.microsoft.com/t5/Developer/Connecting-to-datasets-through-power-bi-publisher-for-excel/m-p/809264#M20991 <P>I connected an excel file to a dataset in powerbi.com through "Connect to data" in Power BI tab in excel (available by installing Power BI publisher for excel.</P><P>&nbsp;</P><P>As I get the dataset as columns and rows in a pivot table, at a certain point (in which I was adding one further field to the pivot table)I got the following message:</P><P>&nbsp;</P><P><FONT size="4" color="#FF0000">"Query execution encountered an MDX construct that is not allowed in direct query models".&nbsp;</FONT></P><P>&nbsp;</P><P>I don´t understand how MDX could possibly have relation to that, as the dataset was published on powerbi.com (it's was a .pbix file published as a report in a workspace), hence tabular.&nbsp;</P> Thu, 03 Oct 2019 18:23:09 GMT Anonymous 2019-10-03T18:23:09Z https://community.fabric.microsoft.com/t5/Developer/Connecting-to-datasets-through-power-bi-publisher-for-excel/m-p/809264#M20991 <P>I connected an excel file to a dataset in powerbi.com through "Connect to data" in Power BI tab in excel (available by installing Power BI publisher for excel.</P><P>&nbsp;</P><P>As I get the dataset as columns and rows in a pivot table, at a certain point (in which I was adding one further field to the pivot table)I got the following message:</P><P>&nbsp;</P><P><FONT size="4" color="#FF0000">"Query execution encountered an MDX construct that is not allowed in direct query models".&nbsp;</FONT></P><P>&nbsp;</P><P>I don´t understand how MDX could possibly have relation to that, as the dataset was published on powerbi.com (it's was a .pbix file published as a report in a workspace), hence tabular.&nbsp;</P> Thu, 03 Oct 2019 18:23:09 GMT https://community.fabric.microsoft.com/t5/Developer/Connecting-to-datasets-through-power-bi-publisher-for-excel/m-p/809264#M20991 Anonymous 2019-10-03T18:23:09Z