User Profile
DP333
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Column of Functions
Hi I am using the Autodesk Assemble connector to connent to Autodesk and view CAD model data. I am able to get to a table contianing all my projects but inorder to get all the detials I must select one of the funtions in the "Value" column specify the properites for the data to be pulled. I would like to pull all the data into one table but can't seem to figure out how to do this for all functions in the column and combine it into one table. It seems can only do one function at a time. When I click on one function it gives me one table. How can I loop through this column and extract the data from each function and merge them into one table. Any idea how to do this?"InvalidFileSizeError" when upload for temporary storage with Rest API
I am trying to upload a pbix file that is over 2 gb using Power Shell and the Rest API. Reading the Post Import In Group documentation I see I have to upload to a temporary location and then pass a "fileUrl" in the body of the import request. I used this Power Shell script provide by Microsoft. The upload of the file to temporary storage works fine but I get "code": "InvalidFileSizeError" when trying to import the file from the temporary storage. I did see this one post on the forum about passing the size of the file in the header of the import call but not sure how to do that as I see no reference to this in the documentation. Before reaching out to support I wanted to see if anyone else has a solution to this? Any suggestions are greatly appreciated! Successful Upload: Error:Powershell Cmdlet New-PowerBIReport Conflict Action Error
Hi, I am trying to upload a new upload a report with the New-PowerBIReport cmdlet. I am able to upload a report but when I reupload the same report it doesn't overwrite the previous version. When I specificy the conflict action below I get the following error. New-PowerBIReport -Path $locationString -Name "test" -WorkspaceId $destinationWorkspaceId -ConflictAction CreateOrOverwrite | Operation returned an invalid status code 'Conflict' Has anyone encountered this?Embed for Customer Direct Query vs Import
I am embedding dashboard into a webiste. We were creating a PBI datasest and connecting multiple reports to it via direct query. We are have performance problems and I think most of them would be taken care of if we switched to Import. We are using a A1 Sku for the embed. As I understand it, the A skus relate to compute capacity but not the storage size of the data model. Is this true? Do I have to pay for storage costs seporately? If so, does that mean I would have to buy premium capacity or how does it work? I tried searching but I found mostly confusing information so any info is greatly appreciated.Blank Measures and Dimension table with Direct Query to PBI Dataset
Hi, I have a PBI Dataset connect to a database using import mode. I am then connecting multiple reports to this dataset with direct query. When I refresh the PBI Dataset, my report connected to the this dataset goes blank. I see can see data for my dimension tables but none of the data for the fact table and accosiated measures are blank. This behavoir is the same in Desktop and Service. Addtionally, I can see all the data and all the meause work in my main dataset which imports the data. Any ideas where this issue can be coming from? Could it be a gateway issue?Switch Dataset source to a database with blank tables
Hi, I am working on a big customer owns data embed project. We are changing the Dataset parameter to point to a specific customers database. We are trying to create one data model to make the reports easier to manage. Some customers don't have all tables that are defined in our "standard data model" so the data won't load when the parameter is changed. Does anyone know of a solution to this issue?
