Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
GrantTrevor
Regular Visitor

Access tables from a Direct Query Dataset in a Blank Query

I'm trying to work out if it's possible to access Tables that exist within a Power BI dataset that is using Direct Query from another Query.

 

Steps so far:

* New Power BI Desktop Report

* Add Power BI Dataset from Power BI Service

* Switch to Direct Query storage mode

* Click 'Get Data' -> Blank Query

 

None of the tables from the Dataset appear in the left hand Queries view when Power Query open.

 

I've tried accessing the tables within the Advanced Query editor using a number of approaches all of which result in an error

 

I understand I can't modify the tables in the original Dataset but I would like to create a new Table based on data in the Direct Query Dataset.

 

"DataSource.Error: AnalysisServices: The user "....." does not have permission to call the Discover method."

3 REPLIES 3
amitchandak
Super User
Super User

@GrantTrevor , the Power bi dataset will come as full.  And you can do changes or view script as of now.

 

You can try dataflows, in case you want access tables separately. But dataflow is not a model, just a set of  tables in service.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thanks @amitchandak  for that response.

 

I'm not trying to alter the tables in the direct query dataset instead what I would like to achieve is to create a new Table that pulls in data from that Direct Query Dataset but have that table only be present in the Report I'm authoring.

 

This would mean the Report uses two DataSets

* one pulled in via Direct Query

* one that is for this Report only and it contains a Table that pulls/transforms data from the other one.

Any updates or lead on this? I came across the very same scenario.

1) I am provided a PBI Dataset that's published.
2) I am trying to find a work-around to bring in the data as IMPORT mode instead of DirectQuery. 

3) I've tried Transformation/MCode and referencing the DirectQuery table but it's not recognizing it.


Any help on this would be greatly appreciated. Thank you.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.