Data source Error

[ssvr]

Hi,

I'm facing one error whil connecting Power BI with Excel file (which is placed in some share folder)

any idea

Thanks

[quentin_vigne]

Hi @ssvr

Are you on a virtual machine ? 

- Quentin

[ssvr]

No.

I conneted the other two sources (SQL, Sharepoint) along with Excel file with the same power bi report

[quentin_vigne]

@ssvr

Did you try to import the excel file separately in another windows ? Does it work ? 

Microsoft say that: 

Mashups between a cloud source and an on-premises source, in a single query, will fail to refresh in the personal gateway if one of the sources is using OAuth for authentication. An example of this is a mashup between CRM Online and a local SQL Server. This will fail because CRM Online requires OAuth.

This is a known issue, and being looked at. To work around the problem, have a separate query for the cloud source and the on-premises source and use a merge or append query to combine them.