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
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?