sh, repScheduled data refresh on Google Analytics on Server (on-premise)
I want to refresh my google analytics' data on the server (on-premise) and schedule it (not manually) but I get this error. I have founded this: "Not all Power BI Reports can have a scheduled refresh plan created on them. If data source can be connected using only OAuth (e.g. Facebook, Google Analytics, Salesforce, etc.), then cache refresh plan cannot be created. At the moment, RS does not support OAuth authentication for any data source whether it is for paginated, mobile or Power BI reports." So does anyone know any other solutions? (Maybe using Flow or anything else?)
Duration Displayed on Card
Hello, I am working with Google Analytics data and attempting to display a card with the Average Session Duration. I have created a custom column to display this data on my table in Power Query with the following formula: = Table.AddColumn(#"Changed Type", "Average Session Duration", each [Session Duration] / [Sessions]) I know from viewing GA that the outcome I'm looking for is 0:01:17. From working with the data in Excel, I know that I can get the right answer with the following equation: Sum(Session Duration) / Sum(Sessions). When I go to display this value on a card, it shows as a decimal. I changed the Data Type to "Time" to get to the format but I can only Summarize the data with "Count" or "Don't Summarize", neither of which give me the average that I'm looking for. My calculation may be wrong but I can't tell based on the output that I'm getting. Any thoughts on how to get to the right number and display?
refreshing a PBIX file through powershell/any other method.
Hi Everyone, I wanted to ask if it is possible to refresh a PBIX file( in an automated way like power shell script or something). I have a report that uses google analytics data as source. the report needs to be placed at Power BI report server(So can't use the Google analytics content pack) which does not handle scheduled refresh for google analytics data source yet. I am also looking into ways of using google analytics data source in an excel file. Any help or insight into this would be greatly appreciated.Google Analytics Schedule Refresh for Power BI on-premise deployment to Report Server
Hi, Our environment is Power BI on premise, we are using Power BI desktop August 2018 Coupled with the similarily dated Report Server Component. There is no on-line component and as such no gateways of any kind we are on-premise only. I have two questions: 1. Is it possible to schedule refresh a Power BI report that you have deployed to the on-premise Report Server. At a cursory glance it appears to tell ou that you cannot, however I wonder if there are any ways around this. 2. If the data cannot be refreshed on a schedule Does pressing the "Refresh" button in the Report server browser portal actually refresh the data from Google analytics.. It kinda is hard to tell. Thanks, GpDes
