Platform
Products

Know exactly what’s in store
and make the  decisions your 
business needs to thrive in real-time

Products
Connectors
Solutions
Solutions

See how Crisp can be tailored
to meet your specific business
and product needs

About
About

Get to know the people
behind the platform and the
mission that drives us.

News
News

We invite you to subscribe
to our blog for the latest
trends and insights. Read
what others have to say about
Crisp in the press.

  • Customer Login
  • Book a Demo

Power BI

Microsoft

In Power BI Desktop, you can connect to an Google BigQuery database and use the underlying data just like any other data source in Power BI Desktop.

  • Book a Demo

Overview

To connect to an OData feed, select Get Data > OData Feed from the Home ribbon in Power BI Desktop.

 

power_bi_odatafeed

In the OData Feed window that appears, type or paste your OData feed URL into the box, and select OK.

power_bi_odatafeed2

Power BI Desktop connects to the OData feed, and displays the available tables and other data elements in the Navigator window. When you select an element, the right pane of the Navigator window displays a preview of the data. You can select as many tables as you want to import. The Navigator window shows a preview of the currently selected table.

 

You can choose the Edit button, which launches Query Editor, where you can shape and transform the data from the OData feed before importing it into Power BI Desktop. Or you can select the Load button, and import all of the data elements you selected in the left pane.

When we select Load, Power BI Desktop imports the selected items, and displays a Load window of the import progress.

Once complete, Power BI Desktop makes the selected tables and other data elements available in the Fields pane, found on the right side of the Reports view in Power BI Desktop.