Forum Discussion
I cant refresh my queries
- 1 year ago
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!
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.