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,

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

YarSolntsev's avatar
YarSolntsev
Frequent Visitor
9 years ago

Hi!
Yes of course.

Any columns name is cyrilic.

I get this error by criate "datasource" for PBI.

Table: "AccumulationRegister_Продажи_RecordType"
Columns: Recorder,Period,Номенклатура_Key,Подразделение_Key,Стоимость,Recorder_Type

 

Unable to connect: We encountered an error while trying to connect to http://192.168.*.*/IdealShop_Test/odata/standard.odata/AccumulationRegister_Продажи_RecordType?$select=Recorder,Period,Номенклатура_Key,Подразделение_Key,Стоимость,Recorder_Type. Details: ""Hide details
Activity ID:92f6131c-f3f0-02ac-c6e8-86869d3fb7b0
Request ID:6f0ddb81-ba81-d5cf-a141-de263dec5948
Cluster URI:https://wabi-west-europe-redirect.analysis.windows.net
Status code:400
Error Code:DM_GWPipeline_Gateway_CancellationOrTimeoutError
Time:Tue Nov 22 2016 12:11:11 GMT+0300 (Kaliningrad Standard Time)
Version:13.0.1700.631
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi YarSolntsev,

    Large dataset and complex complicated data model could cause the refresh to timeout. Try to reduce the complexity of your report and data model, also consider to break your dataset into smaller datasets.

    Thanks,
    Lydia Zhang

    • YarSolntsev's avatar
      YarSolntsev
      Frequent Visitor
      9 years ago

      Hi Lydia!


      As I undestand that problem is realy.
      The connect DB by ODate method  between a PBI and PBI Desktop is defferent. (
      For PBI Desktop is good work For PBI and the same time it don't work for PBI. Why I should break my dateset? )
      How can I break my dateset?
      Is to change my dateset from one query -

      ...&$select=column1,column2,column3,column4...

      to both querys

      ...&$select=column1,column2...

      ...&$select=column3,column4...

      Is't right?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi YarSolntsev,

        Refresh in Power BI Service could be timeout because of large dataset and complex data model.

        How many visuals in your PBIX file? You would need to delete extra rows and columns in your PBIX file, and simplify visuals in the PBIX file.

        If the above error still occurs, please consider to seperate data into different PBIX file.

        Thanks,
        Lydia Zhang