Forum Discussion
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:- Get data->Sharepoint folder, then sign in with Microsoft account:
- Transform data, select the file and table you want:
- 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:
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.
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:
- Get data->Sharepoint folder, then sign in with Microsoft account:
- Transform data, select the file and table you want:
- 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.
I did try using share point folder connection and followed the steps you suggested. An error occured.
What could be the possible reason of this?
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:
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.
ensure all tabs in worksheet are named EXACTLY as in previous updates.
I received the same message when updated a datasource after three months of successfully updating same. Expression Error: The key didn't match any rows in the table.
My data sourse is a monthly updated xlsx file. My issue was resolved by ensuring all tabs in worksheet were named EXACTLY as in previous updates. One of the tabs in the data had an underscore added. the underscore did not exisit in previous updates. updated the spreadsheet tab resolved the keky didnt match message.