MS access data control

[Anonymous]

Hi All,

I am new to Power BI, Please assist.

Since there is no direct query option in MS Access, Is there a way i can limit the data in import. since my MS Access is huge its taking long time even for changing the column format..

[jdbuchanan71]

Write a query in the Access DB that filters to just the data you want then pull that query into PowerBI.

[Anonymous]

Thanks but that would filter the data all time in the report until i remove it again. I want user to see all data in the power BI report.