Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I've created Azure SQL connection with parameters, it make unable to use directQuery
Doesn't work neither with UI defined connection nor with M script "= Sql.Database(PowerBI_server, PowerBI_database)"
At time of defining connection both parameters where pointing to live and accessible Azure database
Solved! Go to Solution.
It seems like your file is already in "Import" mode (and this is indipendent from the fact you are trying to use parameters when connecting to SQL Server). Do you have any other query loaded to the model? Have you tried creating a parametrized connection to SQL Server from a blank file?
Where did you try to apply the parameter? When I tried to filter rows of a DirectQuery even with a constant, I got the error "This step result is not supportted in DirectQuery mode", not to mention using a parameter. So it seems so far not supported.
@Eric_Zhang, Folding additional operations on top of a custom query isn't supported in DQ mode. You can simply change your custom query to reflect the operation that you are trying to do.
@khaox Your scenario is supported. What's the error you are getting?
There is no error message, I'm unable to use direct query mode with parameterized connection (even if it point to the same server and database as before parameterisation).
It seems like your file is already in "Import" mode (and this is indipendent from the fact you are trying to use parameters when connecting to SQL Server). Do you have any other query loaded to the model? Have you tried creating a parametrized connection to SQL Server from a blank file?
Thanks, Did it from scratch, blank project and direct query works... probably switched by accident
I've defined 2 parameters and applied them directly in M.
Tried this with new connection with same results
User | Count |
---|---|
73 | |
69 | |
36 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
53 | |
45 | |
39 |