Forum Discussion

RafDelgado's avatar
RafDelgado
Icon for Helper II rankHelper II
10 years ago

Power BI Personal Gateway Run as a Service Account

We're developing a report for customers which contains information held in a multi-dimensional SQL analysis setup. Unfortunately the BI Connector does not support this so started looking down the Per...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Well, in thinking about this, that service might be an artifact from at one time having the Data Management Gateway installed (old O365 gateway)

  • elliotdixon's avatar
    elliotdixon
    Icon for Responsive Resident rankResponsive Resident
    10 years ago

    WOW! This is great. Thanks so much RafDelgado - a great fix. Worked perfectly (I did have to change your script to look in the right folder I installed the gateway in - but clear and well set out powershell script made this easy)

    Power BI just became a whole lot better.
    Now I just need them to allow more than 8 updates a day.

     

    Thanks again.

    • greggyb's avatar
      greggyb
      Icon for Resident Rockstar rankResident Rockstar
      10 years ago
      elliotdixon wrote:

      ...
      Now I just need them to allow more than 8 updates a day.

       

      Thanks again.

      Any reason you can't utilize a live connection to SSAS or a DirectQuery model? These modes will alway be up to date with their sources, which you can schedule for refresh as often as you like.

      • elliotdixon's avatar
        elliotdixon
        Icon for Responsive Resident rankResponsive Resident
        10 years ago

        Hi greggyb the current limitations on Direct query such as

        • You cannot add calculated columns or table

        • You cannot change the data type of a column

        • All tables must come from a single database

        Mean I am stuck using Import. It looks like they are doing work to remedy this but for now I am stuck with Import.

        ED

         

  • Erikvbueren's avatar
    Erikvbueren
    Icon for Helper I rankHelper I
    10 years ago

    Hi there,,

     

    We try to get the Personal Gateway running as a service on a Terminal Server but didn't figured out the right way. I would like to try the PowerShell Script (the link is relating to) but cannot download it anymore.

     

    Can you help? Thx!