Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Data Source Credentials Setting Not Visible for Dataset

I created a new Dataset based off a File from a Sharepoint Team Site.  I imported Excel data into Power BI so that the data is automatically refreshed from SharePoint.  I did this twice.  For the first file, under settings I can see:

  • Gateway connection
  • Data source credentials
  • Parameters
  • Scheduled refresh
  • OneDrive refresh
  • Q&A
  • Featured Q&A questions
  • Endorsement

Once I configured the Data Source Credentials, I can schedule a refresh from sharepoint. For the second file, I can only see the following settings:

  • Parameters
  • OneDrive refresh
  • Q&A
  • Featured Q&A questions
  • Endorsement

I can't configure the data source credentials and I can't set up a Scheduled Refresh.  If both data sets were created the exact same way, what would explain why my permissions and settings different for each? 

Status: New
Comments
v-yuta-msft
Community Support

@SlothB77 ,

 

Does the second file also use onedrive refresh?

 

Regards,

Jimmy Tao