cancel
Showing results for 
Search instead for 
Did you mean: 
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!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

@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
Frequent Visitor

@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!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

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!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Khizz68
Frequent Visitor

@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!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

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!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!