Data source unreachable

[Anonymous]

Hello, 

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, 

[harryli]

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. 

[Anonymous]

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]

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

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