Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data source unreachable



I am having this issue when publishing my reprot: 






According to our Analytics team, there is no Gateway to be set here. 

My pbix file has: 

- Additioanl Measures

- Imported table (excel) 


Reprots w/o addtional measures and imported tables works w/o issues.


thank you for your support, 



Helper II
Helper II

Hi @Anonymous 

Go to Power Query Editor, and check each of your tables, there is a reminder on top of your table, you may see power Bi will suggest you replace the data insert method of Direct Query by Import. Then please change it to be Import. 

Super User
Super User

Hi @v-henryk-mstf Are you using Import or Direct Query? You usually get that error message if you use Direct Query and the dataset isn't mapped to a Gateway connection. And what is the path used for the file? 

Community Support
Community Support

Hi @Anonymous ,


For this type of problem, first try to republish this report without referring to the created measure in visual. Refer to a similar solution.


Also check if there is an exception between the local time and the utc time on the service.



If the error persists, can you provide the visual screenshots related to your normal situation in powerbi desktop and the information about the measure formula created, etc.? Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors