Hi I have some dashboards in Power BI and I share them in a Public Link with investors and others employees, cause this way is easier and they don't have to log in to see the reports.But the last times, doesn't matter how many times I update the data, the public link's data doesn't change.I have an excel workbook that is a DB query from Access.
Have you tried loading Excel by running excel /s and then trying to link to it? I've seen all too often something as simple as people saying things aren't working, only for the program to waiting for a prompt which might happen to be in the background....similar kind of "user error".
The /s bypasses all XLStart files, but you may want to disable all add-ons as well for testing.
Future examples will show how to create a temporary Access database and then create temporary tables in the database for processing and report generation - this technique eliminates front end database bloat.
She has a spreadsheet that contains links to many other spreadsheets. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
However, we could not get a variable external link to work.
Let us know if you have found a way to make the path to the external database variable.
He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73.
If you wish to have Juan speak at your next group meeting you can contact him here.
Linked tables are a great way to leverage SQL Server in your app.
The first one is NEVER use a combination of linked tables with local tables in your queries.
The other was the spreadsheet it was linking to had imported data from an Access report. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.