Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the C# SDK and the REST API to do a lot programmatically with a large number of reports, created in Power BI Desktop and connected to databases through either Direct Query or Import Mode. Since there is different functionality between these two modes, I want to be able to identify whether a particular dataset is Direct Query or Import. So far my only way to detect this is to attempt a method that works with Direct Query and, if it throws an exception("Invalid dataset" or "Bad Request"), try the method for Import mode. That should not be the best way to determine the dataset mode, but I'm not sure how else to do it. Are there any good ways to identify the difference between Direct Query and Import datasets without relying on exceptions?
Solved! Go to Solution.
The Set All Connections call is the one I've been using, since I need to change connection strings (but this will currently only work for DirectQuery datasets). In seeking other options, I found that Get Datasources yields the same result: a status code "BadRequest" with the message "Invalid dataset. This API can only be called on a DirectQuery dataset." So it appears that checking for this response from one of those calls is the only way to identify which mode is used?
@rmiranti wrote:
I am using the C# SDK and the REST API to do a lot programmatically with a large number of reports, created in Power BI Desktop and connected to databases through either Direct Query or Import Mode. Since there is different functionality between these two modes, I want to be able to identify whether a particular dataset is Direct Query or Import. So far my only way to detect this is to attempt a method that works with Direct Query and, if it throws an exception("Invalid dataset" or "Bad Request"), try the method for Import mode. That should not be the best way to determine the dataset mode, but I'm not sure how else to do it. Are there any good ways to identify the difference between Direct Query and Import datasets without relying on exceptions?
AFAIK, there's no more elegant way to find out dataset in DQ or Import mode than the "method" you mentioned.
By the way, is the method calling the Get Datasources REST API?
The Set All Connections call is the one I've been using, since I need to change connection strings (but this will currently only work for DirectQuery datasets). In seeking other options, I found that Get Datasources yields the same result: a status code "BadRequest" with the message "Invalid dataset. This API can only be called on a DirectQuery dataset." So it appears that checking for this response from one of those calls is the only way to identify which mode is used?
Update in case others are looking for this: the Get Datasources call no longer returns a BadRequest, but a datasource with a null Name and ConnectionString, so I've had to adapt my code accordingly. I'm also wondering if the response might change again in the future, if/when Import dataset connection strings can ever be changed via API.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |