Forum Discussion

NicoCPH's avatar
NicoCPH
Regular Visitor
4 years ago
Solved

Export data issue in Power BI Service

Hi there,

 

We have a report with two pages. On each page we have a table visualization that includes a Web URL field. The extract option we use for the table is the "data with current layout" one.

 

On the first page the extract works fine both in the service and in the desktop, where the report is designed.

 

On the second page the extract is working in the desktop version, but not in the service. In the service it will mess up the column order and place the Web URL at the end of the extract. It will also mix around in all the other columns.

 

We have tried to re-public the report, but it doesnt help.

 

I think it might be due to an error in the Power BI Service, not being able to support the conditional formatting - Web URL -advanced controls, where we use a link for a column. When we disable the Web URL - advanced control - the extract don't get messed up.

 

 

Has anyone else experienced this?

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, NicoCPH 

     

    Have submited this issue internal to confirm(ICM: 281383446), would update here as soon as possible if there is any update about it.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, NicoCPH 

     

    Can you provide a simplified PBIX file for testing?

     

    Looking forward to your reply, thank you.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • NicoCPH's avatar
      NicoCPH
      Regular Visitor
      4 years ago

      Hi v-zhangti 

       

      I just created a sample file, but it seems that i'm not able to upload it here. What is the preferred method for this?

       

      However it is very simple. I added a new table with one entry:

      id = 1, description = description, name = test, country = country, url = http://www.powerbi.com

       

       

      Then I did the conditional formating, so that when you click the id it opens powerbi.com. Then the trick is to re-arange the name, country, description to something other than how the data is located the in table.

       

      Publish to service + export in current design = Error - columns will not show correctly in the specified order.

       

      Notice that name is after id in the extract, but last on the sample report.

       

      Maybe I should just report this as an error instead of this forum?