Problem refreshing data SQL and EXCEL in onedrive

[JarekKlu]

Hello Power BI Community,

I have a following problem:
My data comes from SQL and Excel file located on onedrive (they are combine in PowerQuerry).
On desktop version works fine and I can refresh it. On service I can configure Gateway connections SQL and it works but I cannot configure excel with onedrive.
When I make just excel it also works but then I don’t have to configure Gatewey, it works just with Data source credentials OAuth2.
But how to make it with two source in one data set.

Br
Jarek

[v-zhenbw-msft]

Hi @JarekKlu ,

Please refer these two post, hope them help.

https://community.powerbi.com/t5/Service/Merging-tables-from-SQL-Server-and-OneDrive/m-p/890478

https://community.powerbi.com/t5/Desktop/Merging-tables-from-two-different-data-sources/m-p/679324#M...

And this blog maybe help you.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.