Hi, I did publish report embed for public access, but de URL doesn't working in a Browser (IE and Chrome). It's stay in load stage all the time. It was working well but, today not.   Could someone help?   ... View more

Already reported in the form, and I read multiple messages about people facing the same problem. https://community.powerbi.com/t5/Service/publish-to-web-won-t-refresh/td-p/135110   For a report I used the Publish to web option, embedded the report in a webpage, and at first all worked fine, the report was updated after a scheduled refresh, so we decideded to roll it out the the main monitor. But now the report doesn't update anymore. The data refreshes fine, but the embedded report keeps showing old data. There is a slicer in the report, and when I use that slicer to select something, new data is shown, but when I select back the previous selected item, old data is shown again. This same behaviour is reported for the embed in Sharepoint option. http://community.powerbi.com/t5/Service/Sharepoint-Report-Refresh/m-p/138602#M20548   I use Chrome as browser, but IE has the same behaviour.   I hope this can be fixed soon, because now we have to update the screens manually every day.. ... View more

In office 365 power BI, I was trying to integrate Facebook from online services but couldn't find the facebook third party services option. Can someone help? ... View more

I am trying to import pbix using the power BI CLI tool: https://github.com/Microsoft/PowerBI-Cli When I try to upload a .pbix, I get this error: "write ECONNRESET" or "read ECONNRESET".   I was able to import the same files for the last few months, but since the update of last week, I am unable to import files.   I managed to import a new file with success (but not every time) but unable with an older report.   UPDATE: The same error seems to come up when publishing a file from the Desktop app.: any earlier pbix seems to show that error.   UPDATE: Network seems to be the issue. I am able to publish any files from an other network. What could be the problem? I already check the ports listed in at this link: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/   ... View more

Hi,   After the latest March release, something seems to have broken. Our working reports in Power BI embedded have started throwing error "Debug Assert Failed: Feature switches have not been registered yet so switch values may not be correct" -  this is happening across all reports / many different types of visuals. The visuals open correctly in Power BI Desktop but throw these errors in power bi embedded (reports embedded in website).    Can you please address this urgently - affecting all reports which were working earlier.   thanks,   ... View more

We are facing some peculiar issue while rendering Power BI Embedded report on IE. The first time the reports loads it does not display the values in X-axis! We are using IE11 and latest(March 2017) PBI version. It works absolutely fine on Chrome.   Initially we got this issue only on 1 system and other systems were showing perfectly, but later we were able to repro it on all the systems. Steps to repro... 1- Check if the report is showing X axis values properly on IE, if it is showing ,add favorite bar, custom bar etc on page 2-  Refresh and check again. And the X-axis will be gone! 3- There is 1 more catch here, if we go to focus mode of the report and then come back then it shows properly. Also if you apply any filter on report from the web page and then clear the filter, then also it starts showing properly.   This we have tried so far: 1- Moved to latest version on PBI(March 2017) from the Feb 2017 version 2- Changed properties of the X axis    We are not able to catch any error using developer tool :(. Any pointers to resolve this issue will be of great help ... View more

Hello Everyone,    I am trying to add report via Power BI Embedded and getting the following error. Let me know what I am doing wrong.   (GET https://wabi-india-west-redirect.analysis.windows.net/metadata/cluster 401 (Unauthorized))   Request URL: https://wabi-india-west-redirect.analysis.windows.net/metadata/cluster Request Method:GET Status Code:401 Unauthorized    Thanks in advance!!! ... View more

Some people in my company are having trouble updating Power BI data through excel, for no apparent reason users lose data access, and when they try to connect they get a connection error message. All users are able to access the data through the browser, but they are not able to access through excel, PBI Publisher is updated, but users receive numerous screens asking for login, but nothing happens, many employees with this problem.   Has anyone else had this problem? ... View more

have created custom column,supposed to have hyper link as below  and the output is   In browser inspects it shown as text(not html). so that i can call "comment()" function in java script, is it possible?     you can find my question here ... View more

Hi All,   I have issues to login to powerbi (Web and Desktop), with my o365 business premium account, aquired from Godaddy, the message is the following:   I have the same issue, i cant login to powerbi.microsoft.com after the godaddy login i have the message:   Lo sentimos... No podemos terminar de iniciar su sesión. Su departamento de TI ha desactivado el inicio de sesión para Microsoft Power BI. Póngase en contacto con ellos para completar el inicio de sesión.     I have been called to Godaddy Support but they don´t know anything about the product, they say to call to Microsoft.. : s   Any suggestion?   Regards.   Bernardo ... View more

I’m having serious troubles working with DAX there are several functions that aren’t working properly, I send you 4 different calculations with the same fields (the fields are in the same table) that Surprisingly Works good with Multiplication Arithmetic Operation but failds with Sum, the problem that I’ve found it’s that SQL statements generated by powerbi are not well generated, here I attach one example that Works * Arithmetic Operation and other sql that fails + Arithmetic operation.  I also found the same problem with divide and with - arithmetic operation.   I belive that the problems resides in the engine which is in charge of generation the sql statement, I really don't understand why generates diferent SQL statement when the only diferent thing is the arithmetic operation that Db have to do with the fields.   I’m working in DirectQuery againts a v11 Oracle database with ODAC121024_x64 driver.   Case 1:  Result --> WORKS PROPERLY Arithmetic operation --> Multiplication DAX Formula in Powerbi--> Calc_test = '10x10_CONTEOPIEZAS_APRENDIZAJE'[PESO_APRENDIDO]*'10x10_CONTEOPIEZAS_APRENDIZAJE'[PESO_METRO_APRENDIDO]   SQL Statement that powerbi generates : Work properly SELECT SUM ( "t1"."Calc_test" ) "a0" FROM ( ( SELECT "t1"."ID_LOTE" "ID_LOTE", ("t1"."PESO_APRENDIDO" * "t1"."PESO_METRO_APRENDIDO") "Calc_test" FROM ( (select "$Table"."ID_LOTE" as "ID_LOTE",     "$Table"."FECHA_HORA" as "FECHA_HORA",     "$Table"."PIEZAS_PESADAS" as "PIEZAS_PESADAS",     "$Table"."PIEZAS_AL_BOOKING" as "PIEZAS_AL_BOOKING",     "$Table"."PIEZAS_AL_CARRO" as "PIEZAS_AL_CARRO",     "$Table"."CODIGO_RECOGIDA" as "CODIGO_RECOGIDA",     "$Table"."PESO_METRO_APRENDIDO" as "PESO_METRO_APRENDIDO",     "$Table"."VELOCIDAD_APRENDIDA" as "VELOCIDAD_APRENDIDA",     "$Table"."PESO_APRENDIDO" as "PESO_APRENDIDO",     "$Table"."CORTE_APRENDIDO" as "CORTE_APRENDIDO",     "$Table"."CONTEO_PESO" as "CONTEO_PESO",     "$Table"."CONTEO_LONGITUD" as "CONTEO_LONGITUD",     "$Table"."FECHA_ULTIMO_APRENDIZAJE" as "FECHA_ULTIMO_APRENDIZAJE" from "POWERBI"."10x10_CONTEOPIEZAS_APRENDIZAJE" "$Table") ) "t1" ) "t1" left outer join (select "_"."ID_LOTE" as "ID_LOTE",     "_"."FECHA_HORA" as "FECHA_HORA",     ("_"."CODIGO" || '-') || "_"."VERSION_NUMBER" as "CODIGO_VERSION",     "_"."VERSION_NUMBER" as "VERSION_NUMBER",     "_"."CODIGO" as "CODIGO",     "_"."STATUS" as "STATUS",     "_"."ID_MAQUINA" as "ID_MAQUINA",     "_"."TIEMPO_ESPERA" as "TIEMPO_ESPERA" from "POWERBI"."10x10_LOTES" "_") "t3" on ( "t1"."ID_LOTE" = "t3"."ID_LOTE" ) ) WHERE ( ("t3"."FECHA_HORA" < TO_DATE('2017-03-04 00:00:00', 'YYYY-MM-DD HH24:Mi:SS')) AND ("t3"."FECHA_HORA" >= TO_DATE('2017-02-02 00:00:00', 'YYYY-MM-DD HH24:Mi:SS')) )   Case 2: Result -->Return exception ORA-00904 invalid identifier Arithmetic operation -->Sum Dax Formula in powerbi --> Calc_test = '10x10_CONTEOPIEZAS_APRENDIZAJE'[PESO_APRENDIDO]+'10x10_CONTEOPIEZAS_APRENDIZAJE'[PESO_METRO_APRENDIDO]   SQL Statement that powerbi generates : in red the part of SQl code that throws the exception ORA-00904 SELECT SUM ( "t1"."Calc_test" ) "a0" FROM ( ( SELECT "t1"."ID_LOTE" "ID_LOTE", (SELECT COALESCE(AuxTableOut.Op1 + AuxTableOut.Op2, AuxTableOut.Op1Casted, AuxTableOut.Op2Casted) FROM (Select Op1, AuxTable.Op2 AS Op2, AuxTable.Op1 AS Op1Casted, AuxTable.Op2 AS Op2Casted FROM (SELECT "t1"."PESO_APRENDIDO" AS Op1, "t1"."PESO_METRO_APRENDIDO" AS Op2 FROM DUAL) AuxTable) AuxTableOut) "Calc_test" FROM ( (select "$Table"."ID_LOTE" as "ID_LOTE",     "$Table"."FECHA_HORA" as "FECHA_HORA",     "$Table"."PIEZAS_PESADAS" as "PIEZAS_PESADAS",     "$Table"."PIEZAS_AL_BOOKING" as "PIEZAS_AL_BOOKING",     "$Table"."PIEZAS_AL_CARRO" as "PIEZAS_AL_CARRO",     "$Table"."CODIGO_RECOGIDA" as "CODIGO_RECOGIDA",     "$Table"."PESO_METRO_APRENDIDO" as "PESO_METRO_APRENDIDO",     "$Table"."VELOCIDAD_APRENDIDA" as "VELOCIDAD_APRENDIDA",     "$Table"."PESO_APRENDIDO" as "PESO_APRENDIDO",     "$Table"."CORTE_APRENDIDO" as "CORTE_APRENDIDO",     "$Table"."CONTEO_PESO" as "CONTEO_PESO",     "$Table"."CONTEO_LONGITUD" as "CONTEO_LONGITUD",     "$Table"."FECHA_ULTIMO_APRENDIZAJE" as "FECHA_ULTIMO_APRENDIZAJE" from "POWERBI"."10x10_CONTEOPIEZAS_APRENDIZAJE" "$Table") ) "t1" ) "t1" left outer join (select "_"."ID_LOTE" as "ID_LOTE",     "_"."FECHA_HORA" as "FECHA_HORA",     ("_"."CODIGO" || '-') || "_"."VERSION_NUMBER" as "CODIGO_VERSION",     "_"."VERSION_NUMBER" as "VERSION_NUMBER",     "_"."CODIGO" as "CODIGO",     "_"."STATUS" as "STATUS",     "_"."ID_MAQUINA" as "ID_MAQUINA",     "_"."TIEMPO_ESPERA" as "TIEMPO_ESPERA" from "POWERBI"."10x10_LOTES" "_") "t3" on ( "t1"."ID_LOTE" = "t3"."ID_LOTE" ) ) WHERE ( ("t3"."FECHA_HORA" < TO_DATE('2017-03-04 00:00:00', 'YYYY-MM-DD HH24:Mi:SS')) AND ("t3"."FECHA_HORA" >= TO_DATE('2017-02-02 00:00:00', 'YYYY-MM-DD HH24:Mi:SS')) ) ... View more

Hello,   I am very new in Power BI. Can anyone please advice whether we can embed or display Power BI Q&A section in custom application. Also can we type question in Power BI Q&A section with different language except english.   Thanks in advance. ... View more

Hello,    I built a report in Power BI desktop from excel table stored in Sharepoint. I published this report in power BI service and created a dashboard.  Everytime I am trying to update the report I receive the following error message :  Failed to update data source credentials.Hide details Activity ID: 2e9a503f-01c4-429f-a266-e091d0b336b0 Request ID: 176e7558-f852-d8bf-a2d6-6c9f0a04cf62 Status code: 400 Time: Thu Mar 02 2017 10:22:45 GMT+1100 (AUS Eastern Daylight Time) Version: 13.0.1700.1256 Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net   Also I can not load my organisation Dynamics data.    What can I do ?    Thank you    Regards    Julie  ... View more

I'm a new user to PowerBI. I couldn't get around with mixpanel connector. It fails on me. the first screen shot works. The second doesn't work. I suspect there's a bug.   The screen shot below has the perfect structure (in my opinion) I verify it in chrome from mixpanel. But it won't retrieve and give me an error code 400 Any help is appreciated. I'm very frustrated......... ... View more

I have a web app that I've integrated with Power BI, and I'm having an issue with KPI visualizations. Specifically, I have a customer that is using KPI, and when my app loads their tile on the page, the "Goal" label where it lists the target figure is getting displayed as undefined. It does the same when I open the tile in my app:   All other tiles load fine, but this seems to be the only place it happens. If I look at the console, I'm getting various errors from the localytics library:     Does anyone have any ideas what might be causing this? Is there something I might be doing wrong when setting up the iframe?   ... View more

When I refresh multiple datasources at once I get this error below, which is fine. Yet, I had one scheduled refresh which failed for no particular reason, because no other job was scheduled at the same time. Sometimes I also get "User Rate Limit Exceeded".   I was looking into Google Analytics API configuration, but could not find any settings where I could increase my quota. I believe it is because it is running on PowerBI credentials.   Error:   Data source type:   Processing error: GoogleAnalytics: Request failed (403): Quota Error: Rate Limit Exceeded Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net Activity ID: a067d38a-4509-4b95-b52f-1a4ddd1d5522 Request ID: 81e28702-d80f-41d1-982a-1182a94f9d59 Time: 2017-02-22 08:31:24Z ... View more

Hello,   I am trying to load "case" object from Salesforce as a workaround the 2000 Limit , but i keep getting the erro msg attached   Please help me solce this issue ... View more

The Marketo connector does not connect to reference data table in Marketo. For instance, I want to filter my activities as the full table will max out my API calls. this is impossible unless I know what the ActivityID column means. Having access to an activity reference table would be helpful. I know this is availabe as part of the Marketo API as other tools have been able to retrieve this data. ... View more