Forum Discussion

Ormesome's avatar
Ormesome
Icon for Helper II rankHelper II
8 years ago
Solved

Publishing from Desktop to Service

Using Power BI Desktop I have developed a report which draws on Google Analytics. After I publish the report to Power BI Service I am unable to refresh the dataset - it requests that I install the Pe...
Need Help
Ormesome's avatar
Ormesome
Icon for Helper II rankHelper II
8 years ago

The issue wasn't Google Analytics, after all.

 

The issue is an imported csv file of calendar data. Power BI is trying to refresh the table but there is no gateway to refresh it from.

 

How do you typically embed a calendar table into your reports?

 

    • Ormesome's avatar
      Ormesome
      Icon for Helper II rankHelper II
      8 years ago

      Thank you.

       

      I initially set up the gateway to get the report running, but this solution (autogenerating the table) seems better to me since the table is being used to facilitate DAX queries rather than enforce data integrity.

       

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Ormesome,

    Yes, it it caused by csv file. Based on my test, if we only use Google Analysis connector in desktop to get data and create a report, after publish it to the service and schedule refresh, it doesn't require any gateway. 

    If you want to create a refresh schedule to refresh the dataset including csv file and Google Analytics, you need to install a gateway then add the csv file as data source if you istall on-premiuses gateway(you don't need to configure data source if you use personal gateway), then you can refresh it successfully.

    Best Regards,
    Angelia