Data refresh issue after Publishing - unsupported data source

[dhshyd]

Dear Team ,

We have a  Office 365 subscription with ( Power BI and SharePoint Site )  account .

Excel sheet is placed in SharePoint site which contians the Connecting String 

Now we read the excel sheet thorugh Query editor and get the Connecting String 

Connecting to Azure SQL DWH and get the data

Displaying in Power BI Desktop

This works fine in Desktop 

When we try to Publish the report to web . When we try to refresh the data we get an error . Unsupported Data source.

Can anyone please help us . How to make it work in Power Bi Web.

How do we troubleshoot the issue .

Thanks in advacne 

Harish 

[ankitpatira]

Which Data source connector in power bi desktop have you used ?