Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I currently have a pro license so I'm not sure how importing Power BI dataset into the desktop file works- it looks like it's premium feature only. From researching, it seems that you can only import 1 table at a time? is that true?
I currently have a Power BI dataset in our workspace and that dataset consists of multiple tables.
If I have a premium license, can I import all those tables or it only allows one table import under premium license?
thanks for your help
If you are trying to read tables from a Power BI dataset (i.e Analysis Services), you would connect using the XMLA endpoint, and this requires the dataset is hosted in a workspace backed by premium capacity or PPU. From Power BI, connect using Azure Analysis Services. Easiest way to get individual data and not connect directly to the model (cube), use a DAX query. Below uses a single evaluate to return the entire customer table.
AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/{worksapce name}", "{datasent name}", [Query="evaluate 'Customer'"])
You will have to do this same method for each table to you want to bring in.
Hope this helps.
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |