Create DAX measures, fields and tables in Direct Query mode

Something new came out just a few weeks ago. We now have the ability to connect LIVE to a SQL Database and use Power Query to create our Query that will later be used in our Power BI Desktop. This is...

power bi

emteka

Advocate I

6 years ago

Direct Query mode with SQL Azure database - not able to add new column using DAX like WEEKNUM or FORMAT. The option to use unrestructed DAX in Direct Query mode switched on

Recent ideas

Power Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...
ben_holmes
New Member
2 minutes ago
Need Clarification
202Views
3likes
2Comments
Make Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...
FrançoisD
Frequent Visitor
16 minutes ago
New
1View
0likes
0Comments
Clone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...
gclements
Helper II
1 hour ago
New
6Views
1like
0Comments
Allow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...
tmihara
New Member
6 hours ago
New
7Views
0likes
0Comments
Support Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...
matthias-bi
Regular Visitor
10 hours ago
New
1.3KViews
18likes
2Comments

Create DAX measures, fields and tables in Direct Query mode

Power Query Parameter create/use when connecting to a dataflow

Make Copilot Approval status for semantic model available through API

Clone a workspace, including its data, to a new workspace

Allow NotebookUtils getSecret() to authenticate with Workspace Identity

Support Synonyms in Fabric Warehouse