Forum Discussion

TePe's avatar
TePe
Icon for Helper IV rankHelper IV
8 years ago

Issue while using a shared dataset via ODATA in Power BI Report Server/Desktop

So we created a shared data source in Report Server based on AdventureworksDW2016 (the dimCustomer table). We want to use it as a data source for Power BI. So I tried first to find out the GUID of th...
ODATA Shared Dataset
mgmeyer's avatar
mgmeyer
Icon for Power BI Team rankPower BI Team
8 years ago

Couple questions:

 

- If you execute the URL in the browser do you see all of the data your expecting to see?

- When you say you only seeing a single column is that in PBI Desktop? You should see another column like 'More Columns' if so you expand that to get the other columns in the dataset.

 

This particular OData API uses Open Types which is like Dynamic columns so when a query is made to the server it can't get the metadata to build the schema for the table. After the query is execute the column information comes back.

stretcharm's avatar
stretcharm
Icon for Memorable Member rankMemorable Member
8 years ago

Make sure you click advanced and select Include open type columns to get all the data.

 

or you can add the MoreColumns in M

 

Source = OData.Feed("http://MyServer/Reports/api/v2.0/DataSets(06ffbf58-b11a-47d0-b17c-18ff44d26c68)/data", null, [MoreColumns=true]),
  • TePe's avatar
    TePe
    Icon for Helper IV rankHelper IV
    8 years ago

    ...so ad least the "include open type" checkmark didn't help... Didn't try the M-Code, yet...

    • mgmeyer's avatar
      mgmeyer
      Icon for Power BI Team rankPower BI Team
      8 years ago

      Did you try to execute the URL in the browser to verify that the columns and data that you want is being returned?