Cloud(ish) questions- Accessing from On-Prem

  • 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.

  • 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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • r5d4 wrote:

    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/

  • The users have PBI desktop and we deploy to PBI on premise.

    The spreadsheet sits in teams.

  • r5d4 wrote:

    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/

  • This was removed by the editor as SPAM

  • 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