I am using CData Connect Cloud with PowerBI to access my data (Sage Intacct). Is there a way to configure a scheduled refresh? Is this even something that Connect Cloud supports?
Best answer by James T
View original
Can I schedule a refresh in PowerBI using CData Connect Cloud?
Userlevel 2
Userlevel 2
One of the great features of CData Connect Cloud’s Microsoft Certified Power BI Connector is that use of the PowerBI Gateway isn’t required to refresh your data!
Once you have published your report to PowerBI.com, you simply need to authenticate to CData Connect Cloud on PowerBI.com like you did for Power BI desktop:
-
Open the PowerBI.com workspace where you saved your report.
-
Open the data-set associated with the report.
-
Navigate to File > Setings. Under Data Source, click Edit Credentials.
-
For Authentication, select OAuth2.
-
Select the privacy level for your organization.
-
-
-
Click Sign in and enter your CData Connect credentials when prompted.
-
On the same page, you can now select Refresh and configure a refresh schedule
-
Configure a Refresh in PowerBI.com
-
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers