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.

crodrojas's avatar
crodrojas
New Member
4 years ago

Good Day Vijay, The options explained are for PBI Desktop, but I found the same under Home Tab>options>Project or Global within the power query of the Dataflow Im trying to create. Unfortunately that doesn't work even though I untick the option of Automatically detect column type. Still adding the additional steps and also I can see a warning   "The query "Name" contain untype columns",

 

I went a bit further and changed the formula of the added step from text to any  and PBI still add the steps to swith it back to text.