Loading excel files in Power BI desktop

Hi, PushkarP 

According to your description, I think you maybe make some mistakes when getting data, you can follow my steps and try again:
1. Go to your Sharepoint page, copy the main URL, like this:

2. Get data->Sharepoint folder, then sign in with Microsoft account:

3. Transform data, select the file and table you want:

4. Create the report and publish, you can go to the setting of the dataset, it says you don’t have to use the gateway to refresh this dataset(because data sources are in the cloud)

You should edit the correct credentials, then you can set scheduled refresh.

I guess that the main reason that the dataset needs a gateway to configure Scheduled refresh is using separate mashup queries to connect to on-premises and cloud sources.

If you just connect to files from Share point Online, you won’t need a gateway to configure Scheduled refresh.

Review data infrastructure dependencies

More info about connecting to Sharepoint on desktop

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, @PushkarP 

I suggest you go to the step menu to find what's the original cause of this problem, and try to follow these links to fix it:

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table... 

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table... 

https://community.powerbi.com/t5/Desktop/how-to-resolve-Power-BI-error-the-key-didn-t-match-any-rows... 

If you still have a problem, please show more details.

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.