Forum Discussion
I cant refresh my queries
This message is show is shown in my screen everytime I try to update my data, the sources are from an excel file
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/893467
This might help!
5 Replies
- hnam_2006Frequent Visitor
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 OnlineBest Regards,
hnam_2006
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-sdhruv
Community Support
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/893467
This might help!