Can we create measures in Power BI Service? If not is there anyway to refresh a .pbix report

[lasthero]

Hi,

I am wondering is there anyway to create measures in Power BI Service, I know its possible in Power BI desktop, but is there a way to do it in Power BI service?

If not, then my second question becomes is there anyway to refresh a data set from a .pbix in Power BI service without a Personal Gateway.  

I ask this because as my company has one drive - business.  So when I link to a dataset thats an excel spreadsheet on one drive, everything works properly and things refresh when I update the excel spreadsheet, but I want a way to create measures and from what I can see I can only do this on Power BI desktop.  

The issue with Power BI Desktop is if i use this as my data set in Power BI Service, when i try updating the dataset it says it can't as I need a personal gateway and need Power BI Pro...

Thanks for any help and if my question is confusing i'll try to clarify..

[BhaveshPatel · Accepted solution]

Yes. You need to set up a gateway to refresh the powerbi desktop file that is uploaded to pbi service. Also, You can use REST APIs/streaming datasets option to programmaticaly push your data to pbi service but it would be more hassle than setting up the gateway. You do not need PowerBI Pro licence to set up a gateway. 

You can not create a measure in PBI Service. 

[Ketchumall]

Hi,

Yes, there is a way to create a measure in Power BI Service.

You need to be in edit mode, and then you click "Open data model" on the top left toolbar. This takes you to your data model, and you'll see the "New Measure" option in the top left. You can create your new measure from here.

[sujana_m]

Hi,

What is another way to create a measure in Service if the "Data model" is greyed out?

[santhoshkj]

Thank you !!! Its working

[BhaveshPatel · Accepted solution]

Yes. You need to set up a gateway to refresh the powerbi desktop file that is uploaded to pbi service. Also, You can use REST APIs/streaming datasets option to programmaticaly push your data to pbi service but it would be more hassle than setting up the gateway. You do not need PowerBI Pro licence to set up a gateway. 

You can not create a measure in PBI Service. 

[prepo]

Hello,

I have a similar problem, I am connecting to the PowerBI service via OneDrive and built the report directly in PBI service. Now, I cannot download it to PBI desktop to create measures or enhance the report. Please recommend any solutions to solve this.

Thanks in advance.

[prepo]

Hello,

I have a similar concern. I am using OneDrive to connect to PowerBI service and used the data from excel to build the report. However, since I never created the base report in PBI desktop, I am unable to download the report. Any help is appreciated.

[lasthero]

Thanks Bhavesh for explanations!

would this be the proper link for gateway?

https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/

Edit:

What is the other way besides using a gateway of doing this? Seems like my organization wants me to fill out a request form which is a bit annoying...

[v-caliao-msft · Accepted solution]

Hi @lasthero,

Yes, if you need to schedule refreshed local file, then you need a personal gateway. The personal gateway is only available with Power BI Pro. It installs and runs as a service on your computer.

Based on my research, there is no other way to refresh local file besides using a gateway. Thank you for your understanding.

Regards,

Charlie Liao