Code Monkey home page Code Monkey logo

youtubeanalytics's Introduction

YouTube Analytics Custom Connector for Power BI

A Microsoft Data Connector or Power Query Connector for YoutubeAnalytics data

The vision:

  • A data Connector
  • A Power BI Template
  • A solution for Youtube Creators

Check on the images of the steps below for a step by step walkthrough on how to get this connector working for you.

Note : Unfortunately, Google has implemented some changes to the way that their Web App works and how it handles authentication that have left the documentation on this repo regarding the creation of the WebApp outdated. The Custom Connector still works and does have everything needed to query the data from the REST API, but I'm unable to provide documentation on how to create the Web app. For that, I'd encourage you to follow the tutorials from Google / YouTube themselves regarding the best way to create a web app for their OAuth as mentioned here (https://support.google.com/cloud/answer/6158849?hl=en).

Step 1: Creating your own Google API project

In order to use this connector, you'll need to create your own Google API Project that will host your specific API credentials. Be sure to check out the following video on how to create that project and how to get the credentials needed.
Google API Project

Make sure that the following scopes are enabled on your apps:

  • yt-analytics-monetary.readonly
  • yt-analytics.readonly
  • youtube.readonly

Step 2: Enable the 'Custom Connector' Preview feature in Power BI Desktop

With the new version of the Power BI Desktop you're now able to add a custom data connector way easier than before. With just a few clicks and creating a few folders you're good to go. Be sure to check out the next video on how to enable this feature and set up your folder where you'll place the custom connector.

Enabling Power BI Custom Connectors

Step 3: Download and Modify the connector

Once you have the API Project in place and also the Custom Connectors folders, you can now download the .mez file and modify it with your Google API Project credentials. This next video will show you how to do that. Installing a Custom Connectors

Step 4: Get the Power BI Template for this connector

This is a simple report with the Data Model in place, a few measures, all queries set up correctly, and 3 reports to give you a jumpstart to analyze your youtube data. Feel free to modify the report or provide any type of suggestions or modifications to it. This next video will show you how to get started with the Youtube Analytics Power BI Template. Using the Power BI Template

Step 5: Provide Feedback!

Go ahead and test out the connector and the template! If you have any issues with it, please create an issue in this repo or leave a comment in any of the videos of this series. Let me know what you think.

Update Log

Date Description
2019-04-21 Added a new parameter to the Daily Video Stats and Daily Subscribers functions called "Country Breakdown" which, by default, is set to 'true' for backwards compatibility, but it can be changed to 'false' so these functions only retrieve a daily summary data instead of having a daily breakdown by country for each dataset.

youtubeanalytics's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

youtubeanalytics's Issues

some error in query

when I have done the mez file, and put it in right place.
I open Youtube Analytics Template.pbit, it show the error message like the attach pic.
How to solve it? please

apply qurey change

query error1

query error2

Multichannel support

Hi Miguel!
I have a question and need your help.
How can I use or change your connector to ensure a possibility of using it for multi channel (the case if I have more than one channel on one e-mail)

Scheduled refresh in Service

Hi Miguel,

Thanks for posting this helpful report. However, is there any way of scheduling automatic data refreshes in Service?

Hope to hear from you!

Joey

Problem with connector

image

Hi, Miguel! I write with a problem (look screenshot). Connector always works well. Before today...
Error message in English - "Cannot apply access to fields in type Null"
In mentioned table (Table: Статистика (Youtube)) there are no "null" values at all.
Can you help me?
Thanks

Is this now supported in Service?

Hi Miguel,

Have you had any luck getting this to work in Power BI Service using either the Personal or Enterprise gateways? I didn't have any luck with the enterprise gateway as my connector was not showing up in the list of available data sources. I got further with the Personal gateway but I got this error when it asked me to update my credentials for the data source.

image

Please let me know if you have any tips.

Thanks,
Parker

Access to the resource is forbidden

Hello again,

I was working with your script and all of a sudden I am getting "Access to the resource is forbidden." I tried clearing the permissions and relogging in but it does not seem to make a difference.

I am able to get to Load the Source
image

But when I do the Navigation to Videos it throws this error "Expression.Error: Access to the resource is forbidden".

image

Any advice would be appreciated.

"Expression.error" access to the resource is prohibited

Hello, I'm having trouble generating reports regarding videos, the API pulls all information such as channel name, all videos, etc... but when clicking to generate video statistics (views, ratings, etc.) access occurs.
The user used is the owner of the channel, I have already given permissions to third-party Apps in the google account as well, but it still occurs.

Has anyone had this problem?

image

Urgent | PowerBI | Youtube Analytics - Custom Connector

image

I have gone through all the videos, created Google API gave all the access required and the youtube videos are also in the same ID as where the Google APIs is created. I can see all the videos listed in query but there seems to be some error. (want to use the power bi template shared)

I tried to change the code by adding end date modification mentioned in one of the thread also. Couldnt get through. I have reached a dead end. I dont have much time so would like some urgent supprt from this amazing community.

Cannot fetch live streams

Hi,
nice job!
I have a YouTube channel with live streams.
I want to fetch YouTube analytics (views, tracking time, average view duration, etc) of live streams (separately) into Bi Desktop with your repo. Now, this is impossible.
Can u help me pls?
Thank u!

[Expression.Error] We couldn't find the file 'WebApp.json'

Dear migueesc123,

First of all, thanks for your guide on Custom Connectors for Youtube API.
It was clear and straightforward to follow, even for a beginner like me.

However, I have encountered some problems with regards to loading the Custom Connector.

Issues:

  1. Opened Power BI -> Get Data -> Other -> YoutubeAnalytics.Navigation (Beta)
    No Icon present, and name is different from your tutorial.

  2. [Expression.Error] We couldn't find the file 'WebApp.json'
    When I try to connect to the Custom Connector (with modified json w/ credentials)
    Power BI claims that it cannot locate WebApp.json

Differences:
Due to different versions & changes with updates, these are some steps that I have taken
that is unspecified in your tutorial

  1. Google API -> Credentials -> OAuth Consent Screen
    Had to add "powerbi.com" under authorized domain, in order to add 'Authorized Redirect URI'
    (https://oauth.powerbi.com/views/oauthredirect.html)

Thanks again, Will be waiting for your response!

Autentification

Hi,
First of all, thanks for sharing this 👍
Well, I'm having this error "redirect_uris" not founded, when I tried to connect the data in power bi(after all the steps).
Any ideia of what i most be doing wrong?

Forget, already workin well!

Data Anonymization Issue

Hi again Miguel,

Ever since the update to the Youtube Analytics API on September 17, 2018, I have not been receiving proper data regarding viewer demographics. This is not a problem with the connector because I receive the same problematic data when using the API Explorer. The following is an explanation of why the data is missing:

https://developers.google.com/youtube/analytics/data_model#data-anonymization

Basically, this excerpt states that if your channel does not meet the minimum traffic requirements, then you will probably be missing some data. Do you know of a potential work around to this issue? And have you seen this issue for your channel's data? I understand that your channel is bigger than mine so you might not be affected. For reference, my channel is www.youtube.com/c/bielite.

Thanks again for all of your work on this. I hope to hear from you soon.

-Parker

Error accessing Table: YoutubeAnalytics.Videos

Wow! You have done a fantastic job not only creating this connector, also providing really clear instructions. I am all the way everything works. Almost. There is just one table I cannot access via the connector. Sadly it is the one table that really matters. For some reason YoutubeAnalytics.Video returns this error:

DataSource.Error: Web.Contents failed to get contents from 'https://www.googleapis.com/youtube/v3/search?part=snippet,id&order=date&maxResults=50&forMine=true&type=video' (400): Bad Request
Details:
DataSourceKind=YoutubeAnalytics
DataSourcePath=YoutubeAnalytics
Url=https://www.googleapis.com/youtube/v3/search?part=snippet,id&order=date&maxResults=50&forMine=true&type=video

I am using Power BI Desktop Version: 2.51.4885.701 64-bit (October 2017)

I am attaching a screenshot of the error too. Any ideas?

Many thanks
Michael

connector error 15oct17

Hard coding channel limits portability

Having to hard code the channel was unexpected. Have to change it to my channel and then rebuild the extension. Makes this not very portable. I'm not sure if there is a way to alter the get data dialog to allow input of the channel value.

I guess the same would be true for the appkey and secret. I don't know that you want all of that going through your API app.

Limited rows to 200 video's views

Hi Miguel, really like your work. I posted on the PowerBI community page about a difference between the total views from your template and the total views shown on my YouTube channel's analytics on YouTube itself. I looked through the code, and see the following:

VidNoNulls = Table.SelectRows(#"Expanded id", each [videoId] <> null and [videoId] <> ""),
   VideoList = List.Buffer(VidNoNulls[videoId]),
   maxIterations = Number.RoundUp( List.Count( VideoList) /200),
   setofVideos= List.Generate( () =>
          [Result = Text.Combine(List.Transform(List.Range(VideoList,0,200), Text.From), ","), Offset = 0, Counter = 0],
                each [Counter] < maxIterations,
                each [Result = Text.Combine( List.Transform(List.Range(VideoList,[Offset]+200,200), Text.From), ","),
            Counter = [Counter] +1,
            Offset = [Offset] + 200], each [Result]),

I'm guessing that you're using the youtube analytics API instead of the youtube reporting API where you may be limited to returning 200 rows, so maybe since I have ~1900 videos, the views for videos after my 200th most watched video of the day, are not counted. Do you think that is why I have a difference? I'm not confident in parsing this code, just a guess, so let me know your thoughts and if you would have a way to incorporate the YouTube reporting API to get around this limit. Thank you!

For reference see the section "Key Differences">"Sorting" https://developers.google.com/youtube/reporting/

Can't get data when using dimensions and metrics containing underscore

Hello,

I am getting an error when I try to retrieve data using the function #"GET Reports".

For example, I've been able to get a report using this query:
= #"GET Reports"(#date(2018, 1, 1), #date(2019, 12, 2), "views,likes,dislikes,comments,shares", null, "day", null, null, null, null)

However, when I try to use any of the metrics or dimensions containing underscores, I get a 400 Bad Request error.

For example, I can't get the watch time minutes by day using the following query:

= #"GET Reports"(#date(2018, 1, 1), #date(2019, 12, 2), "views,likes,dislikes,comments,shares, watch_time_minutes", null, "day", null, null, null, null)

The error message is:

DataSource.Error: Web.Contents no pudo obtener el contenido de 'https://youtubeanalytics.googleapis.com/v2/reports/?ids=channel%3D%3DUCJsDSIpAvTN-_IArn2IyYlA&startDate=2018-01-01&endDate=2019-12-02&metrics=views%2Clikes%2Cdislikes%2Ccomments%2Cshares%2Cwatch_time_minutes&dimensions=day' (400): Bad Request.
Detalles:
DataSourceKind=YoutubeAnalytics
DataSourcePath=YoutubeAnalytics
Url=https://youtubeanalytics.googleapis.com/v2/reports/?ids=channel%3D%3DUCJsDSIpAvTN-_IArn2IyYlA&startDate=2018-01-01&endDate=2019-12-02&metrics=views%2Clikes%2Cdislikes%2Ccomments%2Cshares%2Cwatch_time_minutes&dimensions=day

The same error is obtained for any of the following metrics:

  • annotation_click_through_rate
  • annotation_close_rate
  • average_view_duration_seconds
  • estimated_partner_revenue
  • subscribers_gained
  • subscribers_lost
  • views_percentage
  • watch_time_minutes

Is it an issue? Or am I doing something wrong?

Thank you.

Doesnt work

After read, research about the new way activate the custom connector, finally i could activate the custom connector but give a error when i try to validate the account, google show a error the javascript. So what i can do,

Forbidden access issue

Dear Miguel,
Great many thanks for this connector! I managed to make it work and connect to our YouTube channel, I saw the data, all fine. Then I refreshed and the connection seems to have broken. Even is I try with a new file it doesn't work. I get the error message "Expression.Error: Access to the resource is forbidden."
Any idea what went wrong? Many thanks for your feedback in advance!
Source_access

Originally posted by @nemessj in #36 (comment)

redirect URI

Hi!

I modify Webapp.json and I login with my google account but what redirect URI can I used with CLIENT WEB? Thank you!!!

Brand Account

As Google have made a mandate to review the app for sensitive scope , i try to make an internal app and I was able to get the data. Issue is I am able to get the data only of the channel linked to my account but not of channel of my brand account. I am primary owner of brand account and brand account was created with same email id, still not able to get the data.

Has any one able to get the data from channel linked to email as well as from brand account using the internal app option of google oauth2 api

Credentials Problem

Hi Miguel!

First of all, thanks for all the work for this.

I followed the steps multiple times but I always end with a message saying: Connection can't be established. Delete your credentials and try again later.

The original message, in spanish is the following. Maybe it helps.

No se puede establecer la conexión. Elimine sus credenciales e inténtelo de nuevo

Can you help me with this?

Thanks!

Final Redirect Not Working

Hey Miguel, thank you very much for building this connector. I will get a lot of use out of it when I get it up and running. I have followed your steps and I am getting a problem on what seems like the last step. I select the Youtube Analytics connector via Get Data and go through the login steps. I allow the connector the access to my data and then I get redirected to this screen.

youtubeanalyticsloginproblem

The bar at the top says "approval" so I think it is close. Maybe just a redirect problem? Any help you could give me on this would be greatly appreciated.

Thanks again,
Parker

OAuth Verification & Error 401: invalid_client

Hello, I managed to do most steps in your instructions, however I'm having some issues that I would love some help with.

  1. In order to have the scopes: yt-analytics-monetary.readonly, yt-analytics.readonly & youtube.readonly, I need validate the App and for that, I need to provide Justification of why I need yt-analytics-monetary.readonly & youtube.readonly.

Does something like "Access data for our business intelligence through Power Bi. We aim to get real-time information on monetisation and views statistics, and the following scopes are necessary" work?

  1. To validate, I also need to submit a "Demo video: how will the scopes will be used? (A YouTube video link is required when selecting sensitive or restricted scopes)". What do you suggest for this?

  2. I have the Connector showing on Power BI, but I receive a: "Error 401: invalid_client The OAuth client was not found." error. I'm fairly certain I've done all the correct steps you mentioned, but no luck yet :(

Thanks for any guidance possible!

Login Error

Hi I managed to install the connector totally fine!
However now I am getting this error:
"This browser or app may not be secure.
Try using a different browser. If you’re already using a supported browser, you can refresh your screen and try again to sign in."
Any suggestions?

Youtube Analytics API

Hi Miguel!
Thanks for great job of Youtube Analytics connector.
But I've got a problem: on the google pages there is notification that after 31-of October API will be deprecated and there is some instructions to migrate. When I try to change request url from https://www.googleapis.com/youtube/analytics/v1/reports on https://youtubeanalytics.googleapis.com/v2/reports the Power BI is adding one more "/" in request address
image

This is a guide https://developers.google.com/youtube/analytics/migration#updating-client-library-code
Kindly ask you to help me cause it has very big impact to me

Expression.Error: Access to the resource is forbidden.

Hi

I'm having trouble getting this connector to work, and since I can see you're very responsive to other issues raised here, I thought I'd give it a try.

I've followed all the steps in your videos, i.e. created a Google API project with the YouTube APIs, added an OAuth2 client ID, downloaded the connector and modified it with the JSON file downloaded from the API console. However, when trying to connect in Power BI (both manually and using the template), I just get this:

Expression.Error: Access to the resource is forbidden.

Is there anything I can do to troubleshoot this error? As it stands I'm really not sure where to begin.

Thanks in advance, and thanks for all your work on this great project!

Youtube Analytics Template

Hello Miguel...
I just runing your project successfully following your detailed instructions. It is a nice project.
Now i'm trying to use your Analytics Template but unfortunately i'm unable to open it. Pop up messages said that report file file is corrupt or invalid. I'm running march'18 PowerBI version.

I really thanks in advance for your help.

Regards,

Alex-

Crash Log attached...

Feedback Type:
Frown (Error)

Timestamp:
2018-03-24T22:47:34.1570945Z

Local Time:
2018-03-24T19:47:34.1570945-03:00

Session ID:
6892ac1f-b40f-427a-b403-d3350c21fa95

Release:
March 2018

Product Version:
2.56.5023.1021 (PBIDesktop) (x64)

Error Message:
'C:\Users\Alex\Youtube Analytics Template.pbit' is corrupt or an invalid report file.

Stack Trace:
at MS.Internal.IO.Zip.ZipIOEndOfCentralDirectoryBlock.FindPosition(Stream archiveStream)
at MS.Internal.IO.Zip.ZipIOEndOfCentralDirectoryBlock.SeekableLoad(ZipIOBlockManager blockManager)
at MS.Internal.IO.Zip.ZipArchive..ctor(Stream archiveStream, FileMode mode, FileAccess access, Boolean streaming, Boolean ownStream)
at MS.Internal.IO.Zip.ZipArchive.OpenOnStream(Stream stream, FileMode mode, FileAccess access, Boolean streaming)
at System.IO.Packaging.ZipPackage..ctor(Stream s, FileMode mode, FileAccess access, Boolean streaming)
at System.IO.Packaging.Package.Open(Stream stream, FileMode packageMode, FileAccess packageAccess, Boolean streaming)
at Microsoft.PowerBI.Packaging.PowerBIPackager.Open(Stream storageStream, Boolean& requiresConversionToReportLayout, Byte[]& securityBindings, Boolean skipValidation)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Open(FileStream fileStream, IPowerBIWindowService windowService, Nullable`1 entryPoint, Boolean& allCredentialsSatisfied)
at Microsoft.PowerBI.Client.Windows.Services.TemplateManager.TryImportTemplate(IPowerBIWindowService windowService, IQueryServices queryServices, IExceptionHandler exceptionHandler, TelemetryUserActionId entryPoint, Boolean& editQueries, String filePath)

Stack Trace Message:
File contains corrupted data.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Exception exception)
at Microsoft.PowerBI.Client.Windows.Services.TemplateManager.TryImportTemplate(IPowerBIWindowService windowService, IQueryServices queryServices, IExceptionHandler exceptionHandler, TelemetryUserActionId entryPoint, Boolean& editQueries, String filePath)
at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.ImportTemplate(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, ImportTemplateParameters parameters)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Windows.Commands.CommandFactory.<>c__DisplayClass421.<FromSyncHandlers>b__3f(UICommandParameter1 p)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.<>c__DisplayClass2.<.ctor>b__0(Object arg)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.d__7.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.Execute(Object parameter)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.<System.Windows.Input.ICommand.Execute>d__4.MoveNext()
at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.System.Windows.Input.ICommand.Execute(Object parameter)
at Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassa.<>c__DisplayClass10.<

b__3>d__12.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassa.<>c__DisplayClass10.b__3(MainWindow mainWindow)
at Microsoft.PowerBI.Client.Windows.MainWindow.<b__4c>d__4e.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.MainWindow.b__4c()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.d__3.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func1 asyncFunc) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext() at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func1 asyncFunc)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWindowContainer owner)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassa.b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.b__6()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 en-US)

CLR Version:
4.6.2 or later [Release Number = 394802]

Peak Virtual Memory:
33.9 GB

Private Memory:
242 MB

Peak Working Set:
345 MB

IE Version:
11.2125.14393.0

User ID:
b93653de-6d24-47c0-aa5e-f037dbb20a2e

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:

Enabled Preview Features:
PBI_EnableReportTheme
CustomConnectors

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

Problem with Redirect URI

Creating my first Google API Project - Connecting to the Youtube API(https://www.youtube.com/watch?v=6r8hrDHUv6s)

i have an issue when i have to enter the URI in the creation of credentials step. The error message i receive is "Invalid Redirect: domain must be added to the authorized domains list before submitting.
2019-08-24 075111

impossible to connect

Hello,

I follow 3 first steps to get youtube data Analytics, but I can't connect after choosing (in powerbi) your youtube Analytics (beta) connector

connect1

connect2

In google console I write the right redirection url
google

But I have the following message when I enter my gmail account (this is not a supported browser...)
authentification-problem

Thanks

Refresh in PowerBI Service | Sign in

Hi Miguel,

I am trying to do a refresh on the PowerBI service. I have the gateway installed and I have it detecting the connector, however, when I go to try to set the credentials in the Service it asks me to log in. I select the autenthication method Oauth2 and also choose the privacy level, afterwards it asks to trust and I say yes then it takes me to the Oauth 2.0 Playground.

From there I am kinda stuck. What do I have to do here for it to log in in the PowerBI service?
I've been trying to check around but no luck.

image

Thanks in advance,

Web.Contents failed to get contents from

Hi there,
Thanks for looking into this. I opened the template (having followed the directions of all the other video) and I'm receiving this error. I feel like I'm so close but so far away from making this work.

youtubecapture

youtubecapture2

Problems with data!!!

Miguel, Hi!

Today I have received a big problem with connector.

Only part of data was uploaded. In my reprort I have start date equals 01/01/2018 and end date - today.
But today morning I have seen the data only from 22/04/2020.
Its about daily video stats function. I dont know what is going wrong. Connector works.
Yesterday everything was perfect.

Could you help me pls?

Connector appears to be missing statistics including views, likes and comments

Hey, I've got the connector working and am excited about the potential. However, I appear to be experiencing issues with respect to the data being loaded.

I have 279 videos and started my channel in August 2016.

The connector is under-reporting the views, likes, shares, comments, etc. for any video I've manually checked, including the "What if Ryan Reynolds did Christmas Carpool Karaoke". I've attached a screenshot of what I see in Power BI and what I get directly from YouTube Analytics.

BTW. I definitely DON'T have any filters set in Power BI!

Thanks!
view count
20181227 YouTube Analytics Watch Time Report.xlsx

MULTIPLE ACCOUNTS CONNECTION

Hey !

First of all, thanks for sharing your connector and template.

Concerning your connector, would it be possible to add multiple accounts on a same report with all the datas you can currently getting from your connector (i.e revenue, watch time ...).
For example, if I want to connect 4 different youtube channels through a common dashboard with the total combined revenue and watchtime of the 4 channels, is it possible ?

Thanks !
Max

Issue connecting to data

Thanks for quick response. Still I am not able to get the data in preview too.
image

I think there is some change in getting credential with is not discussed in help file

When i create a credential at global level , both youtube analytics, and youtube data v3 api were enabled , i also enabled youtube reporting api and created the json file
image

In Oauth Concent screen tabl ,

I was asked to add authorised domain powerbi.com without which redirect url can not be entered , so i did that

Also it ask for scope , if i do not include scope , i get the above forbidden access error but if i add youtube data and analytics scopes , it ask for submit app for verification which is no where discussed in video created for telling how to get oauth . Need your support ,
Request you to create a new credential for yourself , to see this issue . Old oauth file may still be working for you

image

I am not able to use this , please suggest how can i get the data , Yes i am the primary owner of the channel , doing from same email id

Originally posted by @sachintholia in #29 (comment)

YouTube Analytics Automated Refresh

I successfully got the data pulled in from YouTube Analytics to Power BI. I got it published to Power BI Service and wanted the data to automatically refresh. I got an error "Power BI does not support YouTube Analytics automated refresh" when trying to set up automatic refresh in Power BI Service. Has anyone else had this issue, if so can you help me fix it? Thanks!

YouTube Analytics automated refresh

Troubles with VideoStats

Hello Miguel!

In the Video Stats I noticed that when I set a start date of for example, 01/01/2010 and end date of 09/04/2021 I will get the data, but only after 26/02/2018.
It is only returning 100 videos when there should be at least 140 (considering the date-range I mencioned).

If I set for example a start date of 01/01/2010 and an end-date of 25/02/2018 I will get the following error:

image

All the examples I provived had both false for country and partner.

I am trying to understand why it is happening but no luck :(.

Have you had this issue?

Thanks in advance,

How do you make the click handler wait for the api to load?

Hi, this may not be relevant to this project, but I posted a question on your youtube video and was instructed to post on the github page - I hope this is okay and my question is in the right area.

I am trying to make a call to the youtube data API v3, and am finding that the click handler on my button to make the call can fire the handler making the call before the API client library is loaded. How do you make the click handler wait (to function like a promise, for example) so that the call function will not fire until all necessary api components have finished loading. Pics of my code are attached and a pic of the error that happens if the button is clicked before the API loads. Thank you for any help.

Index.html with button that makes the API Call:

indexhtml
Scripts file loaded into index.html:

scripts

The error when btn is clicked too soon (shown in console in devtools):

asyncerror
Just to be clear, the call and the button works, it's just that if it is clicked too soon, there will be an error - I want to make it so that when the button is clicked, even if it is too soon, the handler will wait for all of the API to load before it fires the call. Thanks again.

File not saved as .mez

Hello

First thank you so much for your videos.
In the step where you paste the Youtube connector in the custom connectors document. I don't have this folder in my documents and I also don't have it in program file.
This is my power bi directory: C:\Program Files\Microsoft Power BI Desktop\bin
and in the bin document I don't have custom folder. I pasted the Youtube connecter in the bin file but it didnt' appear in power bi.

Login/ Verify Google: "Try using a different browser."

Hi,

I am going insane with the OAuth stuff. I've been using this Power Bi connector for YouTube analytics. It was working just fine the last time I tried it in February. Now I wanted to use it again and make full use of it, just to find out that Google changed something and I am not sure how to fix that issue.

Now every time I try to log in and verify my Google Account IN POWERBI it keeps giving me the following message:

"You are trying to sign in from a browser or app that doesn't allow us to keep your account secure.
Try using a different browser."

Maybe it has something to do with the change of Google's oauth process, maybe not.
But since I am a noob with these things I need help on how to fix it.

yt-analytics-monetary.readonly
yt-analytics.readonly
youtube.readonly

I've added these. However, there are several yellow warning signs, just like on the screenshot you've added to issue #30

I am not sure if it's related or not but I have zero idea how to get it working, maybe someone in here has it.

Forbidden access error

Hello:

I have setup you connector with success, but can only access to Channel and Countries tables, and in preview I can see videos data, but when I push de Load Data Button I get a "Forbidden access" error.

Any clue?

Thanks in advance!
Preview
Forbidden

Access to the resource is forbidden

Hello! I am getting an error in Power Query: "Expression.Error: access to the resource is forbidden." This was working for me at the beginning of last month, I'm not sure what changed between then and now. If it seems like it's something on my end please let me know, I wanted to make sure I reported it here though. Thanks!

Video table Error, Access to the resource is forbidden

Hi Miguel,

At one time the connection is all good but after I tried to edit the Youtube Analytics Template 'Top50Videos14Days' table's search pattern, I lost partial access to Youtube Analytics Data.

If I open an empty pbix file, connects to Youtube Analytics, 'Channel' and 'Countries' table still come in but 'Videos' table says Access to the resource is forbidden, any idea?

the link to a screen shot is beloow
https://www.screencast.com/t/ILM0Utyal

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.