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,Description

It’s not all columns in this table!

  

Everything works fine. The columns "Ref_Key" and "Description" is imported from the table and loaded into the model PBI Desktop. 

However, after the publication it in the PBI and destination data source through Odate, doubt that the set of columns specified after the SELECT, the table is ignored and will always try to boot from all existing columns.

Is this true?

 

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    192.168.xxx is an address on your internal network - we can't see it.  If you copy-paste more details of the query you are running and the output you get, it will  help sort out what's happening.

    • YarSolntsev's avatar
      YarSolntsev
      Frequent Visitor
      9 years ago

      Hi Steve!

       

      My more advanced problem in the following.

      I try to connect Table to PBI by local GateWay.
      If Table is small (2-4 colums and 50000 rows) that everything good connect.
      If Table is big (15-50 columns and more 100000 rows) that is can't connect by timeout GateWay.

  • 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