Merge queries are not working after publishing the report

[Khizz68]

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 version

Power BI service:

Power 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.

[meenakp]

Hi,

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

[Greg_Deckler]

@meenakp - That was a great question!

[meenakp]

@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 🙂

[Khizz68]

@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. 

[Greg_Deckler]

Your logic makes sense to me @Khizz68 !

[Greg_Deckler]

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. 

[Khizz68]

@meenakp ,

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

[Khizz68]

Thanks @Greg_Deckler !!

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

[Greg_Deckler]

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!

[Greg_Deckler]

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".