cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rick4him Regular Visitor
Regular Visitor

Additional Publish to Web Limitations using Data Set from Power BI Service

According to this site, https://docs.microsoft.com/en-us/power-bi/service-publish-to-web Publish to Web Limitations are as follows:

 

 

However, if you create are Power BI report using a data set from the Power BI Service and you create a measure on a table, the "Publish to Web" option will not come up after publishing to the PBI Service.  Once you remove the measure(s) and re-publish, the "Publish to Web" option appears.  It is an easy fix, to add the measure to the data set and re-upload, it will not affect reports that are already using the dataset.  This is happenning through this version of PBI Desktop.  Version: 2.54.4970.961 64-bit (January 2018)

 

 

 

7 REPLIES 7
Community Support Team
Community Support Team

Re: Additional Publish to Web Limitations using Data Set from Power BI Service

HI @Rick4him,

 

Can you please explain more about your scenario? I'm not so clarify for your issue.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Rick4him Regular Visitor
Regular Visitor

Re: Additional Publish to Web Limitations using Data Set from Power BI Service

1st upload a dataset (does not require the report portion), then create a new report that uses the dataset from the PBI service, this is done by using "get data" then select Power BI Service and then select the dataset from the workspace you saved the dataset to.  Then, create a measure on the data set, say count of records (do not use the visual count of records, but create a measure resulting in a new column in the dataset).  Put this column on a visual, like the table visual.  Save and publish to app.powerbi.com.  Open on app.powerbi.com, under file, you will not see the "publish to web" option.  Update the report in the desktop by removing the measure and displaying any other data point, save and publish and the "publish to web" option will return under file.

Community Support Team
Community Support Team

Re: Additional Publish to Web Limitations using Data Set from Power BI Service

HI @Rick4him,

 

I follow your steps to create table visual based on power bi service datasource.
After publish to service, 'publish to web' feature still works on that report.

9.PNG


In my opinion, I'd like to suggest you check below limitation list to confirm if your original source suitable these conditions.

Publish to web from Power BI

Limitations

Publish to web is supported for the vast majority of data sources and reports in the Power BI service, however, the following are not currently supported or available with Publish to web:+

  1. Reports using row level security.
  2. Reports using Analysis Services Tablular hosted on premises.
  3. Reports shared to you directly or through an organizational content pack.
  4. Reports in a group in which you are not an edit member.
  5. "R" Visuals are not currently supported in Publish to web reports.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Rick4him Regular Visitor
Regular Visitor

Re: Additional Publish to Web Limitations using Data Set from Power BI Service

Hi v-shex,

 

While I value your opinion, you have not reproduced the issue because you missed the step to create a meause on the service data set after publishing the dataset.  I saw there was a desktop update however that did not help the issue.  With no changes except including or not including the measure built on a service data set, the publish to web is removed when the meause exists.  

 

Steps to reproduce:  Publish a data set to the app.powerbi.com service, open a new report in the desktop user get data and select service and then select the dataset you published to the service, then create a measure on a column on a table (note you do not need to put the measue in a visual, the existance causes the issue), publish the new report, open report on app.powerbi.com, you will see no publish to web option under file, update the report using PBI desktop and remove the measure you created, republish and the publish to web will come back. 

 

In my option, I would suggest that Microsoft either fix the issue or update the limitations to include measures on service data sets.

Community Support Team
Community Support Team

Re: Additional Publish to Web Limitations using Data Set from Power BI Service

Hi @Rick4him,

 

Ok, current I can reproduce this issue.
I will report this issue to power bi team and update here with their feedback.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
ilarioduo Frequent Visitor
Frequent Visitor

Re: Additional Publish to Web Limitations using Data Set from Power BI Service

Hello,

 

first post here, sorry i f I am breaking any rule.

I jumped into this thread since I find exactly the same issue discussed above.

No news from the team I suppose?

Rick4him Regular Visitor
Regular Visitor

Re: Additional Publish to Web Limitations using Data Set from Power BI Service

None that I have heard, only 2 so far have noticed, one would think it would be more prevelant as creating measures causes the upload to bloat and there is only a 2 hour limit to get it up there, that is a serious issue in my opinion, we are considering stopping use of the PBI service for data sets and instead use an Azure or on-premise Tabular Analysis server, not as convenient but no limitations at our model size.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,195)