Forum Discussion

YarSolntsev's avatar
YarSolntsev
Frequent Visitor
9 years ago

Problem to connect from ODate in Power BI(service)

Hello Guys! The PBI Desktop did a project with a connection from the data source OData following:   http://192.168.1.32/IdealShop_Test/odata/standard.odata/Catalog_Enterprise?$select=Ref_Key,Descr...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi YarSolntsev,

Based on your description, you add $select=Ref_Key,Descripti... in your OData feed URL, do you want to get specific columns of table into Power BI Desktop using this method? If that is the case, you can import the whole table into Power BI Desktop, then remove unwanted columns in Query Editor, please check the following example. To remove all unwanted columns, you can select them then click “Remove Columns”, or you can select essential columns(Ref_Key, Description, etc)  then click “Remove Other Columns”.



This way, once you publish the Power BI Desktop, everything should be works well.


Thanks,
Lydia Zhang

YarSolntsev's avatar
YarSolntsev
Frequent Visitor
9 years ago

Hi Lidya!

 

Yes, I can to select and add specific columns of (Odata) Tabe to PBI Desktop by PARAMETR - "$SELECT".

This metod to work is good in PBI Desktop application, but it don't work in PBI. I don't  undestand, probably I need to use pay version PBI? )
In your solved - "Add all columns then remove all unwanted columns" is not good, because UNWANTED COLUMNS to many.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi YarSolntsev,

    As mentioned in my first reply, you can can select essential columns(Ref_Key, Description, etc)  then click “Remove Other Columns” to remove unwanted columns, it will not take you much time if you only want to reserve few columns.

    In addition, could you please post the full error message about timeout?

    Thanks,
    Lydia Zhang