Warehouse direct query problems on Power Bi desktop

[NBEN66]

Hi everyone, 

We have created a Warehouse for storing our Salesforce data and manipulating it as it needed.
At the moment we have 6 main tables:

These tables are filled with a data pipline that contains 4 dataflow gen2, this is working flawlessy data is refreshed once per day without issue. 
The issue comes after refreshing, after every refesh some of the tables at random stop working via direct query and I get the following error messages in BI desktop:

I also get this error message on the dataset that has been created by the warehouse:

Sometimes this error messages does not come up but I would have empty tables in BI while the data is in the warhouse and I get back blank values on visuals. 

Does anybody has any idea why is this happening and how could I fix this ? 

[v-tianyich-msft]

Hi @NBEN66 ,

According to the error message. No corresponding file was retrieved. There seems to be a special string recognition error, including but not limited to "",-,? etc. Try simplifying the name.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[NBEN66]

Hi,
At the beginning I have used simple names such as "assest" as standalone, it did not work with that as well. I thought the names were to simple and that caused an issue so I changed them to more complicated ones. 

I have opened a support ticket, because I am pretty sure this is an issue on Microsoft side. 

Regards,

Bence

[lbendlin · Accepted solution]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .