February 3, 2022 at 12:51 pm
My organisation is rather behind on cloud stuff.
Some quick questions that searching isn't helping me with.
Folk have a spreadsheet in teams (sharepoint).
How can import it into SQL 2019 (on prem) ?
alternatively -
Can I point PowerBI (on prem) straight at it.
I can see requirements for both questions tbh.
I appreciate permissions will be part of the answer, but should I be looking at a specific tool / method?
Apologies if this is in the wrong group, thank you.
February 3, 2022 at 2:02 pm
A spreadsheet into the database is pretty much any of the standard stuff. You can link to the database from Excel and insert from there. You can script stuff out in PowerShell. You can build something in SSIS. You can look to 3rd party tools for data movement. All the same stuff, cloud or not.
PowerBI can connect to Azure, AWS, or GCP.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 3, 2022 at 4:33 pm
Can I point PowerBI (on prem) straight at it.
What are you saying here? The users are using Power BI desktop, and need to point to a spreadsheet? Or have you installed Power BI Report Server?
Either case, connecting to a spreadsheet with Power BI is fairly trivial. What issues are you having?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 3, 2022 at 4:40 pm
The users have PBI desktop and we deploy to PBI on premise.
The spreadsheet sits in teams.
February 4, 2022 at 7:08 pm
The users have PBI desktop and we deploy to PBI on premise. The spreadsheet sits in teams.
What have you tried?
Here, the typical manner is that spreadsheets are stored in SharePoint, and a cdata connection is made to them with PowerBI. Some of them have been changed to SharePoint lists.
There are a few, I think, that are stored on the file system. I'm not sure what specific connection they are using to pull that data in, though.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 21, 2022 at 7:41 pm
This was removed by the editor as SPAM
June 21, 2022 at 7:42 pm
This was removed by the editor as SPAM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply