topic Re: can I use new measure on power bi web part? in Developer

can I use new measure on power bi web part?

KevinTsai — Mon, 26 Jun 2017 16:54:05 GMT

can I use new measure on power bi web part?
Hi:
Does anyone know how I can multiply two aggregate together on power bi online?
The reason I don't use Desktop is that I would like to update my data in real time.
I send data to dataset by using power bi rest api. Then the value on dashboard
could be updated synchronously. Now I would like to sum up two column,
calculate percentage, and create line chart. Can I do this on power bi online?

Thank you

Re: can I use new measure on power bi web part?

Anonymous — Mon, 26 Jun 2017 17:10:13 GMT

The service is for sharing reports. The Desktop is for building them. You can't create measures online.

Re: can I use new measure on power bi web part?

KevinTsai — Mon, 26 Jun 2017 17:18:34 GMT

Hi KHorseman:

Thank you for the answer.

If I would like to update my data in real time on power bi. Could l use power bi Desktop?

My situation is that I have an Azure table and I would like to

create a percentage line chart from two column on power bi.

Whenever my table is updated, the line chart can be updated too.

Is there any way to do this?

Re: can I use new measure on power bi web part?

Anonymous — Mon, 26 Jun 2017 17:19:40 GMT

Have you looked into Direct Query?

Re: can I use new measure on power bi web part?

KevinTsai — Mon, 26 Jun 2017 17:28:52 GMT

Sorry, I haven't.

Does it support for Azure Table?

Based on this website, it does not support for table storage.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

Re: can I use new measure on power bi web part?

Anonymous — Mon, 26 Jun 2017 17:33:45 GMT

Azure Table? I don't know about that. I thought you meant a table in an Azure SQL database.

Re: can I use new measure on power bi web part?

KevinTsai — Mon, 26 Jun 2017 17:51:28 GMT

I really appreciate your reply.

Azure Table Storage is a NoSQL table in Azure service.

But I think power bi may not support connecting Azrue Table on web part.

Re: can I use new measure on power bi web part?

Anonymous — Mon, 26 Jun 2017 18:01:23 GMT

Desktop does support connecting to Azure Table. I don't know about Direct Query because I don't have an Azure Table to test it with. But you do.