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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Khizz68
Frequent Visitor

Merge queries are not working after publishing the report

Hello,

I am merging tables , those are append Queries of SQL queries. Merging works perfectly fine in desktop version but after publishing, it is not showing all the records. I figured out that final merge queries are not giving all the records so it is not showing proper visuals. Please find the screenshots below:

First ss is Desktop and second is from Power BI service:

Desktop versionDesktop version

Power BI service:

Power BI service versionPower BI service version

When I first publish it I can see the same report as per the desktop version but as soon as I refresh (scheduled or on-demand) i starts giving wierd results. Everytime I refresh it gives me wrong results. If I download that PBIX file and refresh it on desktop it works perfectly fine but again evenif I republish it starts behaving wrong.

I have set up the privacy level settings as 'Organizational' same on both for the datasources. But still I dont see any improvements.

 

 

10 REPLIES 10
meenakp
Resolver I
Resolver I

Hi,

Is the credentials used for refresh the same? - in Desktop and Service?

@meenakp - That was a great question!


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler, Thanks!

I have faced this in other reporting tool...

The credentials thing may slip out of mind when working with mutiple data sources especially..

I would almost want @Khizz68 to double check all data sources 🙂

@meenakp @Greg_Deckler 

I have checked all the datasource credentials and they are correct. Even I do not see any errors while providing the gateway connections because I have given the same credentials as per the desktop. 

Actually I am appending all datasource queries to append queries in Power BI and doing merge queries on them.

So, I checked append tables are getting all complete records but final merge is not getting desired records. So, If append tables are getting all the records from different datasources than I think credentials are not the issue. 

Your logic makes sense to me @Khizz68 !


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Yes @Khizz68 I agree that you may want to double check things as mentioned by @meenakp . Remember, it is not who you are logged into in the Desktop and in the Service, it is how the data connections were setup and if there is a gateway involved whether or not the credentials are different there perhaps and something doesn't have access to the data. 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@meenakp ,

Yes!! I am using same credentials on both, Desktop and service.

Khizz68
Frequent Visitor

Thanks @Greg_Deckler !!

I have posted this issue on given link. Hope I can get the resolution!!

Anytime @Khizz68 , sorry I couldn't do anything but refer you to Issues/support but I don't see how that we could troubleshoot that one in the forums. But, you never know, sometimes somebody else has experienced a similar issue and knows something that helps!


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors