Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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.

KEITHO

Storage mode mixed Direct Query issue with multiple users

Submitted by on ‎08-12-2020 07:39 AM

The closest post I have to my issue is:

https://community.powerbi.com/t5/Desktop/Direct-Query-On-SQL-Server-on-Windows-Authentication/m-p/32...

 

However, this person indicates the reason he could not resolve the issue with microsoft is that his AD user account did not have access to the database. 

 

I have a storage mode mixed PBI report on my desktop. 

On PBI desktop, I can see the data, refresh works.

Once published, nothing loads and the error displayed is:

Unable to convert an M query in table 'tablename' into a native source query.

Please try again later or contact support. If you contact support, please provide these details

Please note:  Another team member created the report. when he publishes the report, there is no issue Issue arises when i save the report and then publish it. There is nothing special about the query, its a simple select * . I have access to the database in the connection. Using mode as import, this will resolve the issue but we need to use direct query for some of the data sources. We frequenctly share work on reports, this is the first mixed mode report we have used. No there is nothing wrong with gateway (i.e everything is fine in total until i save changes to the same report)

Status: New
See more ideas labeled with:
4 Comments (4 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎08-14-2020 02:16 AM

@KEITHO 

 

Check if it is affected by any preview feature and create a support ticket for assistance if necessary.

 

KEITHO
Frequent Visitor
‎08-14-2020 05:53 AM

The reviewed August PBI Desktop release 2.84.701.0  that came out to day seems to have fixed this issue. I'll do more detailed testing next week. The display of "validate/Continue" now comes up each time i open the report, might be linked to that... I feel pretty sure that did not come up last time, at least not with a validate option?

KEITHO_0-1597409541395.png

 

 

KEITHO
Frequent Visitor
‎09-08-2020 03:07 AM

Issue re-occrring. Case 120090824002996 submitted.

PBI Desktop release 2.84.981.0 64-bit (August 2020)

KEITHO
Frequent Visitor
‎09-30-2020 01:48 AM

Ticket 120090824002996 resolved my issue.

 

Now there is a new version of PBI desktop and it is reocurring again. The validate box is no longer appearing. same issue as before. Is there something that the dev team is unaware of that needs to be checked before each release? Is there some part the testing team are missing? This is causing me alot of frustration and lost time.

Idea Statuses