Cannot See the all columns when imported from cData Connector

[divyamannava]

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 tried to import a single data row that has monitorstatus even then its not getting in the powerbi

[Anonymous · Accepted solution]

Hi @divyamannava ,
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