Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I created some reports in Power BI Desktop, based on Google Analytics data.
Locally everything works fine, but when deployed to Report Server I get the following error either when I try to "refresh now" or in the daily "Schedule History".
Message: | The key didn't match any rows in the table. Table: FACT - New Users. |
Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
Activity ID: | d316022e-92b2-4302-acfe-1f7334fba5ff |
Request ID: | 8de96052-9fff-d9d9-29b1-f208d2abee8e |
Time: | 2017-11-10 15:49:25Z |
I'm ready to deploy some reports to our clients, but I can't do it with this error that I cannot understand.
Anyone had this error, specifically with Google Analytics integration?
Thanks for your help,
Best regards,
Hugo
Сбой последнего обновления: Mon May 31 2021 14:48:16 (Восточный Казахстан)
Последняя попытка обновления завершилась неудачей из-за внутренней ошибки службы. Обычно это временная проблема. Повторите попытку позже. Если эта проблема возникает снова, обратитесь в службу поддержки.
URI кластера: "WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net"
Идентификатор действия: 9b3f63c2-5311-4de6-9811-c085acb47803
Идентификатор запроса: dd4cc931-7fc0-71b0-acb6-d0047e8fe9c9
Время: 2021-05-31 08:48:16Z
перед возникновением проблемы, нами никаких действий не выполнялось. 25.05.2021 данные еще обновлялись, с 26.05.2021 возникла эта ошибка
I have the same problem. Power BI refrshes data in Desktop, but when I try to "refresh now" in PBI Service and while sheduled refresh it comes the error:
Сбой последнего обновления: Wed Jul 03 2019 13:07:29 GMT+0300 (Moscow Standard Time)
Произошла ошибка при обработке данных в наборе данных.Скрыть подробности
Message: | The key didn't match any rows in the table. Table: GA_Str. |
URI кластера: | WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net |
Идентификатор действия: | a5d015b2-7d2f-424e-8169-43da9491ab81 |
Идентификатор запроса: | 3204d364-1679-393c-a101-8b7f0b6f2e53 |
Время: | 2019-07-03 10:07:29Z |
Any ideas how to solve this?
I am facing the same issue. Not sure what logs or steps to share, I have a seemingly regular dataset with some from SQL (filtered by Date) and some from Excel with mappings between fields as well as New columns and the measures for additional calculations/values.
PowerBI Desktop refreshes just fine, its only in the Service via Scheduled Refresh or Refresh Now that i get the error.
I'm having the same problem. Any ideas?
I'm having the same problem. Any ideas?
Hi @HugoAARMartins,
Can you share the detail steps for us to reproduce the issue? Here is a similar thread which you can have a look, please check if you have merged queries in your dataset.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |