cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brady529
New Member

Link to an SQL database via DirectQuery

Hallo,

 

when I connect my SQL Database via DirectQuery in PowerBI Desktop (My System is a Power BI Report Server) so I can not create a measure etc.

Many menu items are roughened.

How to fix the problem?

Many thanks

Michael

1 REPLY 1
mpsrshl Helper II
Helper II

Re: Link to an SQL database via DirectQuery

Hey there,

 

You should be able to create measures using the majority of the out-of-the-box SSAS functions, some of them are unavailable for direct query against a sql query. 

 

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.