Register for the FREE TRAINING…
«How to use Digital Analytics to generate floods of new Sales and Customers without spending years figuring everything out on your own.»
Here’s what we’re going to cover in this training…
#1 Why digital analytics is the key to online business success.
#2 The number 1 reason why most marketers are not able to scale their advertising and maximize sales.
#3 Why Google and Facebook ads don’t work for most businesses & how to make them work.
#4 Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.
#5 The number 1 reason why conversion optimization is not working for your business.
#6 How to advertise on any marketing platform for FREE with an unlimited budget.
#7 How to learn and master digital analytics and conversion optimization in record time.
My best selling books on Digital Analytics and Conversion Optimization
Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.
Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.
Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.
Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.
Data Studio не может подключиться к вашему набору данных. Не удалось получить данные из базового набора данных. Набор данных подключен в течение некоторого времени или нескольких дней после возникновения этой ошибки данные не подключены для диапазона данных
4 ответа
Эта проблема обычно связана с обновлениями базовых данных электронных таблиц, например, с добавлением новых столбцов. В этом случае вы можете обновить поля источника данных, чтобы получить доступ к данным. снова. Кроме того, проверьте наличие изменений в файле, которые могут нарушить соединение, например изменение владельца.
Если это не относится к вашему случаю, я предлагаю перейти в Сообщество Студии данных. сайт, где вы можете задать похожие вопросы и даже получить ответы от команды Data Studio.
4
Tlaquetzal
5 Фев 2020 в 19:45
Похоже, эта проблема может быть связана с тем, что исходным источником является файл листов. Недавно я столкнулся с проблемой, когда указание на представление, созданное на вкладке листа, имело ту же самую проблему.
Мы пытались изменить учетные данные, обновить и т. д., и ничего не получилось. Оказалось, вам нужно перейти к «Управление источниками данных» -> «Добавить набор данных» -> и выбрать Google Таблицы. Вам будет предложено подтвердить подключение к Google Диску. Сделай это. Даже если вы буквально не тянете простыню, сделайте это. Чтобы было ясно, наш рабочий процесс выглядит следующим образом: команда вводит информацию в листы —> лист загружается в BQ —> создает представление вне таблицы в BQ, которое является листом, чтобы мы могли манипулировать им как таковым —> указать панель инструментов к просмотру в БК.
После этого обновите соединение, и вы должны увидеть данные, заполняющие таблицу/диаграмму.
1
seanwsullivan1
28 Апр 2021 в 19:53
Я столкнулся с этой проблемой сегодня (https://twitter.com/wey_gu/status/1385101021576372228) , для источника данных BigQuery, импортируемого в студию данных, по той причине, что тот же источник данных может быть правильно импортирован моей ролевой учетной записью владельца проекта, это подозревается как проблема с разрешением.
При проверке всех предопределенных ролей IAM, связанных с BigQuery, было обнаружено, что роль BigQuery Job User необходима, поскольку действие импорта лежит в основе еще одного инициируемого задания BigQuery.
0
Wey Gu
22 Апр 2021 в 08:37
У меня такая же проблема, потому что я сменил владельца источника данных. Я исправил это, изменив «учетные данные данных». Надеюсь, это решение поможет вам ввести сюда описание изображения
0
Katie
17 Май 2021 в 14:19
A Google Sheets data set is connected to Google Data Studio then explored in chart using data range.
For 1 or 2 days, data is visible in chart and we can also set range that period of time but after 2 days it shows the screen:
The data set is connected for some time or some days after this error occurs:
Data Set Configuration Error
Data Studio cannot connect to your data set. Failed to fetch data from the underlying data set.
Nimantha
6,6626 gold badges27 silver badges66 bronze badges
asked Jan 21, 2020 at 12:44
1
I got the same issue, because I changed the owner of data source. I fixed it by changing the «data credentials».
Nimantha
6,6626 gold badges27 silver badges66 bronze badges
answered May 17, 2021 at 11:19
KatieKatie
511 silver badge1 bronze badge
1
This issue seems to be normally related to updates in underlying Spreadsheets data, for example, adding new columns. If that’s the case, you can refresh the data source fields to get access to the data again. Also, check for changes in the file that might break the connection, like change of ownership.
In case this does not apply to your case, my suggestion is to go to the Data Studio Community site where you can check similar questions and even get responses by Data Studio team.
answered Feb 5, 2020 at 16:45
TlaquetzalTlaquetzal
2,6551 gold badge11 silver badges18 bronze badges
Looks like this issue may stem from the original source being a sheets file. I recently came across an issue where pointing to a view that is made off of a sheet tab was having this same exact problem.
We tried changing credentials, refreshing, etc and nothing worked. Turned out, you need to navigate to «Manage Data Sources» —> «Add Dataset» —> and select Google Sheets. You should be prompted to approve connection to Google Drive. Do this. Even if you are not literally pulling a sheet, do this. To be clear our workflow is as follows: team inputs information in sheets —> sheet is loaded in BQ —> create a view off of the table in BQ that is the sheet so we can manipulate as such —> point the dashboard to the view in BQ.
Upon doing so, refresh the connection and you should see data populate the table/chart.
answered Apr 28, 2021 at 16:53
In my case, it was the data source owner.
by changing the owner it works for me , because had a permission issue with the owner
- Click on Data Credentials on the top menu.
- Update Credentials Owner
answered Jun 17, 2022 at 4:56
Akitha_MJAkitha_MJ
3,66622 silver badges18 bronze badges
I encountered this issue today(https://twitter.com/wey_gu/status/1385101021576372228), for the BigQuery data source being imported in data studio, for the reason the same data source can be imported properly by my project owner role account, it’s suspected as permission caused issue.
By checking all predefined IAM roles related to BigQuery, it’s found that the BigQuery Job User role is needed as the import action is underlying yet another BigQuery Job being triggerred.
answered Apr 22, 2021 at 5:37
Wey GuWey Gu
5171 gold badge6 silver badges11 bronze badges
Go to Edit Connection option in your Data Source. From here select the appropriate data sheet and click on RECONNECT OPTION. This is prompt if any issues identified in your excel and it will automatically fix the issue. Now you data set configuration error will be removed.
answered Jan 28, 2022 at 11:37
vignesh Subashvignesh Subash
2,4971 gold badge10 silver badges15 bronze badges
A Google Sheets data set is connected to Google Data Studio then explored in chart using data range.
For 1 or 2 days, data is visible in chart and we can also set range that period of time but after 2 days it shows the screen:
The data set is connected for some time or some days after this error occurs:
Data Set Configuration Error
Data Studio cannot connect to your data set. Failed to fetch data from the underlying data set.
Nimantha
6,6626 gold badges27 silver badges66 bronze badges
asked Jan 21, 2020 at 12:44
1
I got the same issue, because I changed the owner of data source. I fixed it by changing the «data credentials».
Nimantha
6,6626 gold badges27 silver badges66 bronze badges
answered May 17, 2021 at 11:19
KatieKatie
511 silver badge1 bronze badge
1
This issue seems to be normally related to updates in underlying Spreadsheets data, for example, adding new columns. If that’s the case, you can refresh the data source fields to get access to the data again. Also, check for changes in the file that might break the connection, like change of ownership.
In case this does not apply to your case, my suggestion is to go to the Data Studio Community site where you can check similar questions and even get responses by Data Studio team.
answered Feb 5, 2020 at 16:45
TlaquetzalTlaquetzal
2,6551 gold badge11 silver badges18 bronze badges
Looks like this issue may stem from the original source being a sheets file. I recently came across an issue where pointing to a view that is made off of a sheet tab was having this same exact problem.
We tried changing credentials, refreshing, etc and nothing worked. Turned out, you need to navigate to «Manage Data Sources» —> «Add Dataset» —> and select Google Sheets. You should be prompted to approve connection to Google Drive. Do this. Even if you are not literally pulling a sheet, do this. To be clear our workflow is as follows: team inputs information in sheets —> sheet is loaded in BQ —> create a view off of the table in BQ that is the sheet so we can manipulate as such —> point the dashboard to the view in BQ.
Upon doing so, refresh the connection and you should see data populate the table/chart.
answered Apr 28, 2021 at 16:53
In my case, it was the data source owner.
by changing the owner it works for me , because had a permission issue with the owner
- Click on Data Credentials on the top menu.
- Update Credentials Owner
answered Jun 17, 2022 at 4:56
Akitha_MJAkitha_MJ
3,66622 silver badges18 bronze badges
I encountered this issue today(https://twitter.com/wey_gu/status/1385101021576372228), for the BigQuery data source being imported in data studio, for the reason the same data source can be imported properly by my project owner role account, it’s suspected as permission caused issue.
By checking all predefined IAM roles related to BigQuery, it’s found that the BigQuery Job User role is needed as the import action is underlying yet another BigQuery Job being triggerred.
answered Apr 22, 2021 at 5:37
Wey GuWey Gu
5171 gold badge6 silver badges11 bronze badges
Go to Edit Connection option in your Data Source. From here select the appropriate data sheet and click on RECONNECT OPTION. This is prompt if any issues identified in your excel and it will automatically fix the issue. Now you data set configuration error will be removed.
answered Jan 28, 2022 at 11:37
vignesh Subashvignesh Subash
2,4971 gold badge10 silver badges15 bronze badges
I’m using Postgres connector from a cloud based server to Google Data Studio, to pull in all my Zoho CRM data so that I can build some dashboards in Google Data Studio.
Problem is, for some odd reason it’s refusing to accept some of my date fields, while others it does. Even the exact same field, in one of my Zoho CRM tables it works, another location (sep zoho account) it won’t.
I get this error:
Data Set Configuration Error
Data Studio cannot connect to your data set.
Sorry, we encountered an error and were unable to complete your request.
Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
Error ID: e1c58806
Nothing I’ve done seems to help.
I’m using Panopoly.io as the server.
Zoho CRM Enterprise
And obviously Google Data Studio.
Data Set Configuration Error
Data Studio cannot connect to your data set.
Sorry, we encountered an error and were unable to complete your request.
Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
Error ID: e1c58806
I’m using Postgres connector from a cloud based server to Google Data Studio, to pull in all my Zoho CRM data so that I can build some dashboards in Google Data Studio.
Problem is, for some odd reason it’s refusing to accept some of my date fields, while others it does. Even the exact same field, in one of my Zoho CRM tables it works, another location (sep zoho account) it won’t.
I get this error:
Data Set Configuration Error
Data Studio cannot connect to your data set.
Sorry, we encountered an error and were unable to complete your request.
Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
Error ID: e1c58806
Nothing I’ve done seems to help.
I’m using Panopoly.io as the server.
Zoho CRM Enterprise
And obviously Google Data Studio.
Data Set Configuration Error
Data Studio cannot connect to your data set.
Sorry, we encountered an error and were unable to complete your request.
Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
Error ID: e1c58806
В настоящее время я пытаюсь подключиться к источнику данных, содержащему данные формы. Некоторые поля являются необязательными, например, _vfb_field-1048 — это страна. Когда я добавляю все, кроме необязательных полей, таких как _vfb_field-1048, все работает отлично. Когда я добавляю эти измерения, он говорит мне:
Data Studio не может подключиться к вашему набору данных.
Не удалось получить данные из базового набора данных.
Идентификатор ошибки: 929212f4
Любая идея, что мне нужно сделать, чтобы данные отображались?
Примеры данных (не полные данные, поэтому не обращайте внимания на форматирование):
Мета: {
_vfb_field-1045: «Джон»,
_vfb_field-1069: «15551234567»,
_vfb_field-1046: «Лань»,
_vfb_field-1047: «email@example.com»,
_vfb_field-1048: «США»,
_vfb_field-1049: «Онлайн»,
_vfb_form_id: «72»,
_vfb_entry_id: «13560»
}
Мета: {
_vfb_field-1045: «Джон»,
_vfb_field-1069: «15551234567»,
_vfb_field-1046: «Лань»,
_vfb_field-1047: «email@example.com»,
_vfb_field-1048: «»,
_vfb_field-1049: «Онлайн»,
_vfb_form_id: «72»,
_vfb_entry_id: «13561»
}
function getFields() {
var cc = DataStudioApp.createCommunityConnector();
var fields = cc.getFields();
var types = cc.FieldType;
var aggregations = cc.AggregationType;
fields.newDimension()
.setId('slug')
.setName('Slug')
.setType(types.TEXT);
fields.newDimension()
.setId('country')
.setName('Country')
.setType(types.TEXT);
fields.newDimension()
.setId('form')
.setName('Form')
.setType(types.TEXT);
fields.newMetric()
.setId('id')
.setName('ID')
.setType(types.NUMBER)
.setAggregation(aggregations.SUM);
return fields;
}
function getSchema(request) {
var fields = getFields().build();
return {'schema': fields};
}
function responseToRows(requestedFields, response) {
// Transform parsed data and filter for requested fields
return response.map(function(dailyDownload) {
var row = [];
requestedFields.asArray().forEach(function(field) {
switch (field.getId()) {
case 'slug':
return row.push(dailyDownload.slug);
case 'country':
return row.push(dailyDownload.meta._vfb_field-1048);
case 'id':
return row.push(dailyDownload.id);
case 'form':
return row.push(dailyDownload.meta._vfb_form_id);
default:
return row.push('');
}
});
return {values: row};
});
}