cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Data source unreachable

Hello, 

 

I am having this issue when publishing my reprot: 

 

Fico_0-1654500614677.png

 

Fico_1-1654500629503.png

 

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, 

 

 

3 REPLIES 3
harryli
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. 

wikkleyn
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? 

v-henryk-mstf
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.

vhenrykmstf_0-1654741540711.png

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

vhenrykmstf_1-1654741565287.png

 

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,
Henry


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

Helpful resources

Announcements
Carousel_PBI_Wave1

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