New Idea
0 Kudos

It is a common practice to pin one tile, and then change some of the parameters to change the output,   and then pin that chart. This way you get two charts for the price of one in your dashboards. This is especially  usefull when trying to manage several dashboards from one report, or trying to limit the number of PBIX files and tabs that you have to maintain. However this doesn not work with a pinned live page as the report filter does not carry through to the pinned tile. All live tiles are pinned as-is and applied filteres are not carried through.

 

This means that you have to make multiple copies of the PBIX file and save them individually in order to take advantage of the live pinned tile. This is greatly  increases  the amount of tedious management of reports and dashboards. An improvement would be to retain filters in pinned live tiles.

Status: Delivered
0 Kudos

So I've been trying to sign up for about 3 weeks now, and I keep getting the same error message "Sorry, that didn't work. There's a problem on our end. We're working on it, so try again later."

This problem has been persistant for 3 weeks and I'd like to sign up so I can buy PRO and continue. 
I signed up, got the verification code, put it into the field and continued. |

Help?

 

Erico

 

Status: Needs Info
0 Kudos

Unable to Embed Tabular Model

Status: Needs Info
by adamwallace3 Frequent Visitor on ‎06-15-2017 09:18 AM

Howdy, 

 

I have created a power bi report using an Azure Tabular server for the back end. The report works on the desktop version, and online- but when I try embedding the report I get the following error:

 

Couldn't load the schema for the database model
 
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please try again later or contact support. If you contact support, please provide these details.
Status: Needs Info
0 Kudos

embeded html doesn't update

Status: Delivered
by borderick New Member on ‎05-16-2017 10:52 AM

Hi all,

 

Hope you can help.  I have a report that I've exported to html and it has worked fine in the past.  Now when I update the report the html output is still showing the OLD report, unless I wipe out the old one and publish a new one to web.  Why is this?  Should it not automatically update?

 

Is this a bug? Can someone please help?

Status: Delivered
0 Kudos

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:MiSmiley FrustratedS'))

AND

("t3"."FECHA_HORA" >= TO_DATE('2017-02-02 00:00:00', 'YYYY-MM-DD HH24:MiSmiley FrustratedS'))

)

 

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:MiSmiley FrustratedS'))

AND

("t3"."FECHA_HORA" >= TO_DATE('2017-02-02 00:00:00', 'YYYY-MM-DD HH24:MiSmiley FrustratedS'))

)

Status: Accepted
0 Kudos

TreeMap viz stopped working in embedded tile

Status: Delivered
by Eoin Visitor on ‎03-23-2017 04:16 PM

Hi,

 

We have had embedded tiles (4 in total) in a client app for the past 3 months. Today the 2 of the tiles with the treemap viz stopped working. The fix was to use a pie chart instead (Can't use custom viz).  What happened the API to block treemaps? Is it related to the move of some viz to the app store today? (23rd March 2017)

Status: Delivered
0 Kudos

Tool tip resizing issue

Status: Needs Info
by Kavita Frequent Visitor on ‎03-23-2017 02:59 AM

We have embedded visuals on web page using Power BI Embedded. The issue we are facing is the tool tip does not show up properly i.e the information hides and the words are not wrapped.

 

In the screen shot you can see, the space where visuals are rendered and the tool tip which truncates instead of wrapping the text

 

Tooltip.png

Status: Needs Info
0 Kudos

Error connecting to quickbooks online

Status: Needs Info
by ngombert Occasional Visitor on ‎04-04-2017 02:24 AM

Hello,

 

I'm trying to get data from my quickbooks online account.

While doing so I get this error :

 

Type de source de données : QuickBooks

Traitement de l'erreur : Web.Contents failed to get contents from 'https://quickbooks.api.intuit.com/v3/company/<hidden_manually>/reports/GeneralLedger?date_macro=all&...' (400): Bad Request
ID de corrélation : 6e0748f1-3570-2553-fb74-be7874196fa6
ID d'activité : 22f04e18-a50b-4346-be68-0d3814c5fbc1
ID de demande : 18c48f6f-06de-8b56-9c24-c4bb90fec1ec
Code d'état : 400
HeureTue Apr 04 2017 11:04:59 GMT+0200 (CEST)
Version13.0.1700.1649
 
 
I try to connect to that data source from time to time since a couple of weeks.
The error always occurs
Status: Needs Info
0 Kudos

Keyboard accessibility for Embedded Charts

Status: Needs Info
by rajasri New Member on ‎04-05-2017 03:58 AM

Not all actionable elements in an Embedded Power BI chart are reachable via Keyboard. Please handle Keyboard navigavation for all actionable elements for Keyboard accessible users.

Status: Needs Info
0 Kudos

My public data source(JSON) from our website : https://cdn.datascraping.co/reports/sample-data.txt

 

Error in refresh : 

 

 

 

I created the report from Desktop app and refresh is working fine there but not on powerbi.com

 

let
    Source = Json.Document(Web.Contents("https://cdn.datascraping.co/reports/sample-data.txt")),
    result = Source[result],
    #"Converted to Table" = Table.FromList(result, Splitter.SplitByNothing(), 
null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1",
{"account_id", "account_status", "created_on", "active_plan", "trial_expired_on"},
{"Column1.account_id", "Column1.account_status", "Column1.created_on",
"Column1.active_plan", "Column1.trial_expired_on"}), #"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",
{{"Column1.trial_expired_on", type date}, {"Column1.created_on", type date}}) in #"Changed Type"

 

This is the sample static file as data source I created to put on public forum here. Actually, we were connecting from our web api with key in http get as querystring which is also failing to refresh on powerbi.com but working on desktop without any issue.

 

For example : https://api.datascraping.co/v1/test-endpoint?key=some-key-here

 

Thanks

Status: Needs Info
0 Kudos

Issues with the X axis label in IE

Status: Delivered
by Kavita Frequent Visitor on ‎03-12-2017 11:23 PM

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 Smiley Sad.

Any pointers to resolve this issue will be of great help

Status: Delivered
0 Kudos

Report embed does not work in IE

Status: Needs Info
by heitzmanjared Frequent Visitor on ‎01-11-2017 08:37 AM

I'm attempting to embed a report in an iFrame using the url retrned from the "Get Reports" web service. The url looks like this "https://app.powerbi.com/reportEmbed?reportId={reportid}".  It works fine in Chrome, but in IE (v11) it does not work. Using IE's debugger I can see an error in the javascript of the app.powerbi.com/reportEmbed page.  

 

The line that fails is :

window.addEventListener('message', receiveMessage', false);

 

It should be :

if (window.addEventListener) {
       window.addEventListener("message", receiveMessage, false);
} else {
       window.attachEvent("onmessage", receiveMessage);
}

 

 

I haven't been able to find any other documentation regarding this issue. I (obviously) can't modify the code on the microsoft controlled page, so I'm forced to have our users use Google Chrome.

Status: Needs Info
0 Kudos

Publishing Error to Power bI Service.PNG

 

I update the data which is connected with Excel file and want to re publish on power bi service, so all data gets updated over in power bi service, but after i update the Desktop service with new release of January 2017, it want allowing me to publish the report on power bi and throwing attached error.

 

This is a bug and if this type of bugs happnes it will be difficul for us to have the data upto date on file shared with many people, they can not see the updated report and dashboards.

 

Please have a urgent look and reslove as soon as poosbile.

 

 Embeded code with useing Azure plaform service , there is bug, when we connect data with direct query with SQL data base, its throwing error to update the data, its seems that the live connection with data base having issue. data are not updating on run time basis. this is also a serious bug you guys need to look and test again.

 

Thansk

Naresh

Status: Needs Info
0 Kudos

"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."

 

When updating the crendentials, we get the spinning dots forever. It never resolves. Excel sheets stored in OneDrive for business still work, but Sharepoint and CRM do not.

Status: Needs Info
0 Kudos

Connecting ODATA source

Status: New
by Brigit New Member on ‎11-29-2016 09:14 AM

e are trying to connect to an ODATA source but get the following error message:

 

"We were unable to resolve type name 'Collection(ODATA query)' to an EdmType"

 

Any idea what the reason could be? The ODATA query works fine in Chrome.

0 Kudos

403 Forbidden Add rows to Dataset REST APP

Status: New
by sree007 New Member on ‎11-09-2016 05:13 AM

Hello,

I am using PowerBI API to add row on the dataset by https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-walkthrough-push-data-add-rows/

 

but i am getting following error.

 

An unhandled exception of type 'System.Net.WebException' occurred in System.dll

Additional information: The remote server returned an error: (400) Bad Request.

 

 - Is service broken? or this documentation need to change?

0 Kudos

PowerBI Embedded Azure Service

Status: Delivered
by Kiran_Holi Visitor ‎01-02-2017 07:10 AM - edited ‎01-02-2017 07:19 AM

Hi,

 

We are integrating new powerbi embedded azure service in our web application.

 

The usecase is to embed power bi dashboard/reports and customize them into web application and data source choosen is google analytics. I have created POC of it and able to embed dashboard/reports and its working fine.

 

The problem that I see is Data refreshment Issue for embedded reports/dashboard in the web application and also there is no Auto refresh configuration option exists, means if some data is updated in my google analytics account, those changes are not refelected in embedded reports and dashboard in web application until I do the data refersh manually(recreate a pbix and re-import it to workspace). Is this Problem solved?

 

I dont see even Schedule refresh option for newly launched powerbi embedded azure service.

 

Thanks,

Kiran

Status: Delivered
0 Kudos

Power BI Embedded speed/performance

Status: Delivered
by peril49 Frequent Visitor on ‎01-18-2017 04:49 AM

We are using Direct Query to a SQL database in the same region (North Europe) as the PowerBI workspaces.

All SQL query are taking sub 25ms but the reports are still loading slowly at different times during the day. At other times the reports 

 

Has anyone experianced speed issues with PowerBI Embedded reports? 

 

Status: Delivered

Problems with correlative map(Zip code)

Status: Delivered
by Rayito169 Frequent Visitor on ‎02-14-2017 08:42 AM

Hello,

 

From today( 14/02/2017), we are having problems with correlative map where we use zip code to paint the zone in the map.

Yesterday, this map works correctly. In Power Bi desktop works

 

111.JPG

, but in power bi Embebbed not.

222.JPG

 

Has anyone had the same problem? How can we solve it?

 

Many thanks,

Javier.

Status: Delivered
0 Kudos

Hi, I have some PBI reports embedded in Azure Web Apps. When the web app page opens the web browser gives me a warning:

An embedded page at embedded.powerbi.com says:

debug assert failed warning feature switches have not been registered yet so switch values may not be correct.

Do you know how to disable this warning?

Thank you

Status: Needs Info
Idea Statuses