cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Angel Member
Member

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,

 

 

 

 

4 REPLIES 4
Moderator v-caliao-msft
Moderator

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

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

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

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,

Moderator v-caliao-msft
Moderator

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

Hi @Angel,

 

Please refer to the screenshots below.
Capture.PNGCapture1.PNGCapture2.PNG

Regards,

Charlie Liao

Angel Member
Member

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

Hi, @v-caliao-msft

 

The option you have mentioned is disabled in my case. 

Capture.JPG

 

I must say dataset was created publishing a local Power BI file desktop (no in onedrive neither sharepoint). This local file is the one that access to odata feed.

 

To add up:

   1.- I have created a powerbi desktop file and the way I access is through ODATA Feed

   2.- I published in Power BI

 

I want to refresh in Power BI.

 

Any tip?,

 

Thanks,

 

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors