Forum Discussion

suszonydzik's avatar
suszonydzik
New Member
9 years ago
Solved

Cannot create measure in table obtained by DirectQuery from Azure SQL Data Warehouse

I’ve added data source of type Microsoft Azure SQL Data Warehouse, then I tried to add a measure by right clicking on table name:     but error occurred:     The message says there ...
Data Modeling
Gateways
  • suszonydzik's avatar
    suszonydzik
    9 years ago

    There was a colon sign in my connection string, not comma. After this change I can create measures.

     

    Thanks, for sharing!

    Mark

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

suszonydzik

 

I can create measure successfully while my data source is Azure data warehouse. From the message you posted, it seems that there is a connection problem. Can you get the data refreshed properly while you click Refresh in Power BI Desktop?

What did you type in Server/Database field when you try to get data from Azure data warehouse? I get the connection string in Azure portal as below.

 

 

Best Regards,

Herbert