I cant refresh my queries

[HERNAN17]

This message is show is shown in my screen everytime I try to update my data, the sources are from an excel file

[v-sdhruv]

Hi @HERNAN17   ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @HERNAN17   ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @HERNAN17   ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv · Accepted solution]

Hi @HERNAN17 ,

You can also try the approach mentioned here-
https://community.fabric.microsoft.com/t5/Desktop/Microsoft-PowerBI-OleDb-is-not-registered/m-p/8934...
This might help!

[hnam_2006]

Hi @HERNAN17 

I think the excel file may need to be reconnected. 

Go to "transform data" --> "data source setting". Check the connection or rebuild the connection. 

If you are using SharePoint, i suggest you go to the file location and select the file (dont open it). When you select the file, you can see a "details" pane open. In here, there is a path. Copy that and go to powerBI. In data source, replace the excel path with this SharePoint path and you can ensure file is updated even when your laptop/desktop is switched off. Ofcourse, you need to schedule refresh in PowerBI service

refer to the youtube vide for more details: How to get a file path to a file in SharePoint Online 

Best Regards,

hnam_2006

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