https://community.fabric.microsoft.com/t5/Developer/Modify-schema-only-works-for-push-datasets/m-p/1108285#M23824 <P>Is it possible to add or remove columns from dataset, outside of push data sets?</P><P>&nbsp;</P><P>This API looks to do exactly what I need: <A title="https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_puttable" href="https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_puttable" target="_self">https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_puttable</A></P><P>&nbsp;</P><P>However it only works for push datasets and the dataset I'm working with is too large for that, so I'm using direct query.</P><P>Ultimately I want a way for a change to the SQL Server view I'm connecting to to be reflected in queries to the dataset. Is there any way I can do this?</P> Fri, 22 May 2020 23:00:12 GMT Anonymous 2020-05-22T23:00:12Z https://community.fabric.microsoft.com/t5/Developer/Modify-schema-only-works-for-push-datasets/m-p/1108285#M23824 <P>Is it possible to add or remove columns from dataset, outside of push data sets?</P><P>&nbsp;</P><P>This API looks to do exactly what I need: <A title="https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_puttable" href="https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_puttable" target="_self">https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_puttable</A></P><P>&nbsp;</P><P>However it only works for push datasets and the dataset I'm working with is too large for that, so I'm using direct query.</P><P>Ultimately I want a way for a change to the SQL Server view I'm connecting to to be reflected in queries to the dataset. Is there any way I can do this?</P> Fri, 22 May 2020 23:00:12 GMT https://community.fabric.microsoft.com/t5/Developer/Modify-schema-only-works-for-push-datasets/m-p/1108285#M23824 Anonymous 2020-05-22T23:00:12Z