Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Solution Supplier
Solution Supplier

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors