cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GellaiTamas Regular Visitor
Regular Visitor

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

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

 

2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

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

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.

 

q1.PNGq2.PNG

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GellaiTamas Regular Visitor
Regular Visitor

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

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

 

 

 

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors