Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Cannot See the all columns when imported from cData Connector

when imported i can not see the columns after location id, the moniitorstatus col is also not shown where as some data have monitorStatus some doesnt , i think thats the reason but even i t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,
    According to your description, there are columns of data that are missing when you import data into Power BI using the cData Connector. You can check to see if you have completed the checkmarks for the columns in the subtree of the cData Connector cloud in the preview screen when you select the data to import. Repeat this to see if the import is complete.
    Of course, you can also enter the power query interface after import, open the advanced editor, and check whether the target columns are imported in the code.
    Power Query CData Connect Cloud connector - Power Query | Microsoft Learn

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,
According to your description, there are columns of data that are missing when you import data into Power BI using the cData Connector. You can check to see if you have completed the checkmarks for the columns in the subtree of the cData Connector cloud in the preview screen when you select the data to import. Repeat this to see if the import is complete.
Of course, you can also enter the power query interface after import, open the advanced editor, and check whether the target columns are imported in the code.
Power Query CData Connect Cloud connector - Power Query | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly