Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Direct Query Service Report does not work on Desktop

My question has something to do with both Power BI Desktop and Power BI Service. So I thought it would be better to post it here because ones who know Service most likely have a good understanding of Desktop too. 

There are two Power BI reports (A & B) both are distributed and running on Service. I was asked to edit the reports. I have to edit it on desktop since I am not the author, then the author will upload it on Service. 

Report A is created based on Import and Report B based on Direct Query methods.

I am given the necessary Data Gateway permissions, through which both reports communicate with the SQL server. When I run report A on Power BI desktop everything works fine including the updating.

With report B however I cannot even open the file, let alone the updating. I think there must be a communication problem. 

Someone has any idea why it is so? 


Thanks and Regards


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors