Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello:
I'm having an issue scheduling a refresh on the resultant dataset, which is built from two different datasets (1 dataset from Oracle DB and the other dataset from Excel). The dataset from Excel is uploaded to One Drive since, Power BI has seamless integration with One Drive service.
However, when I try to schedule a daily refresh in Power BI service, it does not recognize the Excel dataset located on One Drive.
As the resultant dataset is dependent on both Oracle and Excel dataset, the connection to Oracle dataset is established, but for Excel it complains of Invalid Credentials.
I'm not sure what could be going wrong here. Any advise is welcome. Please help.
Solved! Go to Solution.
@onbi,
Do you use personal mode gateway or on-premises gateway? In your scenario, you combine on-premises data source and online data source in a single dataset, please review my replies in the following similar thread about how to set schedule refresh in this case.
https://community.powerbi.com/t5/Integrations-with-Files-and/PowerBI-Enterprise-gateway-You-don-t-ha...
Regards,
Lydia
@onbi,
Do you use personal mode gateway or on-premises gateway? In your scenario, you combine on-premises data source and online data source in a single dataset, please review my replies in the following similar thread about how to set schedule refresh in this case.
https://community.powerbi.com/t5/Integrations-with-Files-and/PowerBI-Enterprise-gateway-You-don-t-ha...
Regards,
Lydia
We've configured and are using On-Premise Data Gateway for our Oracle DB datasource.
Thank you for providing the link. I'll try the solution provided in the link and will let you know.
@onbi,
How is the issue going? If you have solved the issue, please accept helpful replies as answer to close this thread.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.