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,

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

    • YarSolntsev's avatar
      YarSolntsev
      Frequent Visitor
      9 years ago

      Hi!
      A few days a go we made the following. We changed Gateway from virtual machine to real machine. Then our problem was solved! )
      From this case we have quastion. Is Gateway mast to installed on the real computer?