Sharepoint Online - Visualize Access data with Power BI in real-time

[GellaiTamas]

Hi,

I'm pretty new to Sharepoint and wondering how could I solve the following issue:

what my boss wants is having (Access) databases on the company's Sharepoint site which can be searched/filtered/etc. by the users. Is there any way to generate a preconfigured chart with simply pushing a button after the user has set the required data dimensions using a form and wants to visualize the data? What is the most common solution for this? Can I somehow use Power BI (maybe through PowerApps or in some other way) to tackle this?

Thanks,

Tamás

[v-qiuyu-msft]

Hi @GellaiTamas,

It seems the .accdb file stores in SharePoint online, right? If that is a case, you can use SharePoint Folder data source in desktop to get files in SharePoint online, then open Query Editor filter data only keep this .accdb file and expand data.

You can create slicer visuals for users to filter data, also you can add visual /page /report level filters.

Publish this report from desktop to service, set schedule refresh for this dataset.

Best Regards,
Qiuyun Yu

[GellaiTamas]

Hi @v-qiuyu-msft,

Thanks a lot for your answer. I think I was not 100% clear - apologies. So what I'm looking for is a solution that can be executed only using Microsoft products to chart/visualize data upon user's input in real time.

Something like this:

http://www.fao.org/faostat/en/#data/QC/visualize

The user sets the desired data dimensions/filters and the chart below (or it can be a popup window or anything else as well) gets automatically generated.

Is there any way to solve this within our Sharepoint-based company portal? If so, can it be done by using MS Access and Power BI within the Sharepoint site? If not, could you please recommend any solution that works?

Thanks,

Tamás