Forum Discussion

Angel's avatar
Angel
Resolver III
9 years ago

On Premises Data Gateaway - Connecting to a data source with two tables inside...

Hi, everybody

 

I have been working with Power BI desktop doing a report.

 

The report use two tables that are in two different ODATA url.  (one for every table). I have done the relationships in Power BI desktop.

 

After that, I have published the report in Power BI service.

 

The next step I want to do is refresh the report in Power BI Service.  I have configured on premises data gateaway to do that.

 

What kind of data source must I use to connect to model data I have already done in Power BI Desktop?. I don't want to lose all the job I have done doing relationships and redoing the report.

 

Thanks in advance,

 

 

 

 

Need Help

4 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    Hi Angel,

     

    When publish report to Power BI services from Power BI desktop. It will publish the data model to services. So when source data updated, those data will apply to this data model.

     

    The data in the data source comes from an OData feed online, you do not need to install a gateway, but you will need to go into the dataset’s settings and sign in to the OData data source. You can then setup a refresh schedule so Power BI automatically connects to the OData feed and gets updated data.

     

    Regards,

    Charlie Liao

     

     

    • Angel's avatar
      Angel
      Resolver III
      9 years ago

      Hi, v-caliao-msft

       

      I'm looking for the options you have mentioned it and I don't know where they are.

       

      Can you send images, please?.

       

      Thanks in advance,