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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!