Forum Discussion
Problem refreshing data SQL and EXCEL in onedrive
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
1 Reply
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
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.
