Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm able to connect to an sqlite.db file stored on my PC, but I don't seem to be able to connect to the the same db if stored on a sharepoint folder. I tried to simply replace the C:\ path with the url. I tried to connect to sharepoint folder and select the file from there, but I still miss that kind of database= string. I have permissions to the site and use my windows credentials for authentication (connecting to any other file works). Am I missing any steps?
Thanks,
Pietro
Solved! Go to Solution.
You cannot. SharePoint libraries do not behave the same as local drives or network shares. Same with Access databases. Access cannot even open its own MDB/ACCDB files in SharePoint. They have to be sync'd locally. Excel, Word, and PowerPoint, and a few others, have been modified to open files directly on SharePoint.
Even Power BI cannot open PBIX files stored in SharePoint - you have to have them local. So your SQL Lite database must be on a local drive to work, and you'll need a gateway to connect to it from the service.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou cannot. SharePoint libraries do not behave the same as local drives or network shares. Same with Access databases. Access cannot even open its own MDB/ACCDB files in SharePoint. They have to be sync'd locally. Excel, Word, and PowerPoint, and a few others, have been modified to open files directly on SharePoint.
Even Power BI cannot open PBIX files stored in SharePoint - you have to have them local. So your SQL Lite database must be on a local drive to work, and you'll need a gateway to connect to it from the service.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingFile based Databases need to be writable. That includes SQLite and Access (which even comes with its own lock files).
You _might_ be able to get your data by explicitly open the SQLite database read only via an ODBC driver. Haven't tried this though.
Another alternative is to use the Folder connector (NOT the Sharepoint Folder connector) and use the UNC path to your sharepoint folder instead, like \\sharepoint.url\site\folder\db.sqlite .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |