cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anhngv
Helper III
Helper III

Can refresh data in Power BI service in free version

Hi, I'm using free version of Power BI and have a problem with refreshing data in PBI service. I have searched and followed some instructions but still not work out.

- So 1st thing I want to know, is PBI service free version available for refreshing data?

- If yes, could someone help me with this. I have installed On-premises data gateway and connect dataset in PBI with my files in my computer (xlsx and accdb files):

anhngv_0-1616032734579.png

But I can't select Gateway (Vietanh) and Apply.

I have datasets and original PBI file updated in my computer but I can't refresh data & report in PBI service.

 

Thanks

1 ACCEPTED SOLUTION

Hi @anhngv 

 

You will need to install the access drivers on your gateway server

How to install 64-bit Microsoft Database Drivers alongside 32-bit Microsoft Office | AutoCAD | Autod...

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
anhngv
Helper III
Helper III

@GilbertQ Sorry for my silly question since I'm new to this. I have mapped data sources to the files and be able to select Gateway and apply. But I still cannot refresh my dataset, can you help check:

 

anhngv_0-1616116631927.png

I click Refresh now but it's still an error

anhngv_4-1616117088114.png

 

 

anhngv_2-1616116904861.png

Thanks

Hi @anhngv 

 

You will need to install the access drivers on your gateway server

How to install 64-bit Microsoft Database Drivers alongside 32-bit Microsoft Office | AutoCAD | Autod...

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

hi @GilbertQ thanks for your hint. I have installed MS Access Database Engine 2016 and it works. And I find that there is a problem with my Access.

I'm using Access 2010 x64 for the database. Whenever I open my Access file, the system process something that makes this error occurs again. Then I have to run MS Access Database Engine again Do you accidentally know to fix this? Otherwise, It's OK and thank you.

Hi @anhngv 

 

I am not sure why that is happening with Access.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @anhngv 

 

have you clicked on the drop down and mapped the data sources to the files?

 

Once that is done you should then be able to refresh your data.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors