Multiple sources in Power BI

[Anonymous]

Hi Everyone,

I have a Power BI desktop with 2 sources: one from a local file and one from OneDrive file.

When I upload the desktop to my Power BI online I find a problem.

I configure the Gateway and the data source and everything is ok.

When I go to the dataset configuration the option is disabled:

There is any problem with an only report with two diferents sources?

Can anyone help me?

Thanks. 

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

In your scenario, you need to install and configure the personal gateway. You can download the On-premises data gateway, then select Personal Gateway instead of On-premises data gateway to install the personal gateway. Then the Gateway connection option will be available.

Reference:
Gateway connection 

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[Anonymous]

Thanks @v-qiuyu-msft!

So it´s imposible to do this kind of reports with on-premise gateway.

Then, it is better to use the Personal Gateway?

[v-qiuyu-msft]

Hi @Anonymous,

Yes, for this report, you need to configure personal gateway.

Best Regards,
Qiuyun Yu

[Anonymous]

Ok, Thanks @v-qiuyu-msft.

One last question:
It is posible to have both gateways at the same desktop?