Web.Contents failed to get contents from 'https://ausreman.tidywork.com/api/materials' (400)
I have tried a number of scenarios for posting data, but I have come up with nothing. I am trying to write a power query that posts data to a REST API (https://ausreman.tidywork.com/api/materials), it posts data for materials. The current query I have is: = Json.Document(Web.Contents("https://ausreman.tidywork.com/api/materials",[Headers= [#"Authorization"="Basic ZZZZZZZZZZZZZZZZZ",#"Content-Type"="application/json"], Content=Json.FromValue({[projectId="65b6d1fe-ec2e-47c3-9c92-2aad8fdd1d26",userId="67220adb-d5cb-4667-a3ce-ebe3d6248334",materialDateUtc="2015-09-14T07:11:00",materialDate="2015-09-14T17:11:00",materialId="00000000-0000-0000-0000-000000000000",materialLocationId="1aeb9552-a3e9-4804-a7b2-641b290dac8d",materialItemCode="1H3338",materialItemId="f9be8264-81f0-4ae2-a12b-569b3e05d034",costCurrencyId="17709522-6b2e-4b01-9cdf-bb7eb0a43c52",chargeCurrencyId="17709522-6b2e-4b01-9cdf-bb7eb0a43c52",taskId="b2ffc2cf-326a-fc91-eb40-c4ddb4147a35",state="Approved",usageQuantity=1,quantity=1,cost=0.21,charge=0.25]})]), 1252) The only thoughts I had was that it had something along the lines of the size of the data being post. Please help me remove this frustration.
Need Help: Error 8657 accessing Dataverse contact table in Power BI/Excel
Hi Experts, I need your help with this issue (Error 8657 accessing Dataverse contact table in Power BI/Excel). Microsoft Support just responded that it's a backend issue and they're unable to do anything about it. It's been a week since we started getting this error. Please help me to resolve it and guide me on what we can do next. Regards.
Appending columns and creating new column of old column headers
I have a table with data imported from multiple weather stations. The imported data has multiple rows of headers - one row giving the location/ID and one row giving the data variable. I have put an example of how the data looks below. I would like to append the columns so there is one column for rainfall etc from all locations. This would require a new column to identify the location for each row. I have tried to see if I can arrange this with Power Query but I can't find a way to get it to recognise two rows of headers. Or is there another way this can be achieved?
Can't edit applied steps in Power Query Online (Dataflow)
Hi all, I am facing an issue during the Dataflow creation process. I am currently working with SAP BW as a Data Source. I used to work directly in Power BI Desktop where I had no issues but my customer decided to switch to Dataflows. The problem is that I want to edit the step where I added data to add more fields to the dataset itself. To achieve this, in Power Query in PBI Desktop i clicked on the gear icon next to the appropriate applied step: Switching to Dataflows, in Power Query Online I don't find this option anymore: It looks like the Dataflow step is locked. I still can perform the edit using the advanced editor but it is a bit tricky because I have to use the technical names associated to the fields by SAP BW. I did not find anything useful in the Microsoft Documentation. Can someone help?
Access.Database and Web.Contents on Macs
Hi, Any expert on Power Query for macOS there ? 😉 I have an Access database in my Dropbox pro folder and I would like to to be able to work on it on my Mac when I am at home. So to connect the Access database to PQ without a local path, I can manage through Web.Contents() I can also manage to have it on another PC since this is not locally dependent on my PC at work However, I hav tried to use Web.Contents() in my Mac, I do see the file but I cannot drill down to the table as I cannot use the module Access.Database Any help, lead or workaround would be greatly appreciated
