Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Merge

Power BI reporting is connecting to analysis services data model . I have been using the merge option in Analysis services to bring  few fields in to one of the table.

 

now, the merge is no longer required . I have deleted merge queries in analysis services ( path is : Table-> Table Properties ->Design->Power Query editor). but, when I reopen the table again it showing the merge queries.

 

was there any issue with configuration?

1 ACCEPTED SOLUTION
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

I don't understand clearly. Can I ask some questions?

  • You connect AS to Power BI.

What the connection mode do you use? Import mode or Live connection?

  • You have deleted the merge table. However you still can view it. 

Do you merge tables in AS? And you delete the merged table and still can view it in Power BI. Right? if so, do you try to refresh manually? Can it refresh successfully? If no, is there any error message?

1.PNG

 

Or you merge and delete all in Power Query Editor. But you still can view the merge query in it. If you are in this situation, can you please share a few screenshots? I can't reproduce it. The screenshots can help us to understand clearly.

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

View solution in original post

1 REPLY 1
v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

I don't understand clearly. Can I ask some questions?

  • You connect AS to Power BI.

What the connection mode do you use? Import mode or Live connection?

  • You have deleted the merge table. However you still can view it. 

Do you merge tables in AS? And you delete the merged table and still can view it in Power BI. Right? if so, do you try to refresh manually? Can it refresh successfully? If no, is there any error message?

1.PNG

 

Or you merge and delete all in Power Query Editor. But you still can view the merge query in it. If you are in this situation, can you please share a few screenshots? I can't reproduce it. The screenshots can help us to understand clearly.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.