Hi Neeko ,
Yes , I can connect to snowflake Database using same server details. I can also create PBI reports from dekstop using the same snowflake server and other details.
My intention is not to create reports yet from the dataset that datamart generates. At the moment I want to create a datamart , which is suppose is possible only in PBI service , This datamart will then be a layer in between database and our datasets . What we are trying to achieve here by bringing a datamart layer between DB and Datasets is to have the common tables refreshed only once via datamart instead of same table refreshing multiple times when each dataset refreshes.
I'm able to connect to same snowflake DB via desktop , publishing reports to PBI , create new reports off existing datasets. pretty much everything including working in DB.
But anything to be created new in PBI service is causing this error for everyone in team!