import multiple access queries from network locationns

Hi darrylwilson,

We may write some Power Query (M) language to get the data from multiple data sources, but it is not available to assign permission on particular query in M language. Well currently I am not very good at M query, maybe ImkeF could help in your scenario.

The available way that I could think out currently is:

All users access the same Access Database stored in a File Share, then enable ABE in the File share, thus users could only access his own database file;

Then every user access the database file using Power BI Desktop to generate reports, if those reports need to share with others, publish them into Power BI Service, and share the dashboard, or create content Pack.

How should I share Power BI dashboards and reports?

For Access reports, currently this is not supported to have it import into Power BI, importing Access report into SSRS is possible:

Import Reports from Microsoft Access (Reporting Services)

And we could then pin SSRS reports into Power BI Dashboard:

Pin Reporting Services items to Power BI Dashboards

Regards