Forum Discussion

crodrojas's avatar
crodrojas
New Member
4 years ago
Solved

Power BI adding steps after Save&Close

Hello Everyone, I'm having issues with a dataflow Im trying to setup and not sure why this is happening. All Im doing is connectig thorugh sharepoint folder connector, doing some filtering to get t...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi crodrojas 

     

    I'm afraid the Table data type is not supported in Power BI dataflows. You could refer to this doc: https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-features-limitations#:~:text=Not%20Supported-,Table,Not%20Supported,-List 

     

    Based on my test, when I tried to save and close a dataflow which has a table column in a query, I could save it successfully. But when I opened it to check the steps again, I found it automatically adds the following step to remove the table column before saving. Apparently columns of unsupported data types (table, record, list, binary, function) are removed automatically. 

    Table.RemoveColumns(#"Merged queries", Table.ColumnsOfType(#"Merged queries", {type table, type record, type list, type nullable binary, type binary, type function}))

     

    I suggest that you expand the table column to bring all table data into the table before applying. In Power BI Desktop, although you can close and apply it successfully, you will find this table column doesn't exist in the data model. You can check the Data view after applying. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi crodrojas 

 

I'm afraid the Table data type is not supported in Power BI dataflows. You could refer to this doc: https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-features-limitations#:~:text=Not%20Supported-,Table,Not%20Supported,-List 

 

Based on my test, when I tried to save and close a dataflow which has a table column in a query, I could save it successfully. But when I opened it to check the steps again, I found it automatically adds the following step to remove the table column before saving. Apparently columns of unsupported data types (table, record, list, binary, function) are removed automatically. 

Table.RemoveColumns(#"Merged queries", Table.ColumnsOfType(#"Merged queries", {type table, type record, type list, type nullable binary, type binary, type function}))

 

I suggest that you expand the table column to bring all table data into the table before applying. In Power BI Desktop, although you can close and apply it successfully, you will find this table column doesn't exist in the data model. You can check the Data view after applying. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.