Table is not getting load in Power BI Desktop App and Dataflows as well.

[Amardeep100115]

I have successfully being using dataflows to retrieve excel files stored in Sharepoint for several months now.

Last week, I tried to refresh my report today, but the report table shows any value in dataflows but when I try to built same report in PBI Desktop App table get loaded by using file stored in sharepoint.

Please guide

[v-yuta-msft]

@Amardeep100115 ,

Have you copied the code in advanced editor in power bi desktop to dataflow? Also please check if the sharepoint url is valid. 

Regards,

Jimmy Tao

[Amardeep100115]

Yes,

by using same code Power BI Desktop app is successfully loading data, but in DataFlows not