Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ODBC extract inside Remote Desktop through a secured gateway

Hello Everyone,   The subject must be very vauge. So to give you an over view :  - I have my powerBI file on my local computer - for me to get the raw data for my powerbi, I have to login to a se...
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Tough to answer specfically. If this is a setup like I think it is, then they will need to install and configure a Power BI gateway on their network. Then, when you publish the file to their Power BI tenant you could setup auto-refresh. I've had to work in very similar environments before, login to a jump box, do the extract, upload to a web site, download from website, load into Power BI. Incredibly painful and costs everyone time and money in the long run for scant amounts of additional security, if any. Security folks, what are you going to do? If they could prevent everyone from doing anything within a system they would. If a system is completely unuseable, I suppose it's entirely safe.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Tough to answer specfically. If this is a setup like I think it is, then they will need to install and configure a Power BI gateway on their network. Then, when you publish the file to their Power BI tenant you could setup auto-refresh. I've had to work in very similar environments before, login to a jump box, do the extract, upload to a web site, download from website, load into Power BI. Incredibly painful and costs everyone time and money in the long run for scant amounts of additional security, if any. Security folks, what are you going to do? If they could prevent everyone from doing anything within a system they would. If a system is completely unuseable, I suppose it's entirely safe.