Data Analysis

How to overcome SSIS OData v4 date and time issues

MS SSIS does not recognise โ€˜Dateโ€™ or โ€˜Timeโ€™ type fields from an OData v4 source. To overcome this issue, Hubway...

What credentials do I use to access when connecting to the Odata feed?

Select Basic Authentication while connecting to OData feed...

How to consume Hubway Connect service in Microsoft Excel?

Copy the Test or Production service linksย from the Builder Project...

How to implement pagination in Microsoft Excel?

In MS Excel, go to Data โ†’ New query โ†’ From Other Sources โ†’ Blank Query...

Power BI establishes incorrect relationships between Entities. What do I do?

When you consume OData service in PowerBI, we have noticed that Power BI may automatically assume...

How can I achieve pagination in Microsoft Power BI?

Here is aย reference article to loop through OData Entities...