Web.Contents with the Content option is only supported when connecting anonymously.
Hello All, I am connecting to api using basic token. but I am getting the authentication issue which is "Web.Contents with the Content option is only supported when connecting anonymously." i Knew it is very common error and gone thorugh all the below links https://community.powerbi.com/t5/Service/Anonymous-access/m-p/21014#M5916 http://community.powerbi.com/t5/Developer/Using-a-REST-API-as-a-data-source-Web-Contents-Content-option/m-p/115650#M4042 http://community.powerbi.com/t5/Service/Cannot-sign-in-with-Anonymous-Authentication-for-a-Web-API/td-p/168154?lightbox-message-images-168154=39597iD83266D92D25D020 the power Query is let AuthKey = "Basic mytoken", url="https://tfs.mnsu.edu/tfs/ITS%20AppDev/Test%20Agile%20Project/_apis/wit/wiql?api-version=1.0", body="{ ""query"": ""Select [System.Id], [System.Title], [System.State] From WorkItems Where [System.WorkItemType] = 'Task' and [System.AreaPath]='Test Agile Project'"" }", Source = Json.Document(Web.Contents(url,[ Headers = [#"Authorization"=AuthKey , #"Content-Type"="application/json"], Content = Text.ToBinary(body) ] )) in Source and error i am getting is can anyone please hemp
PowerBI Embedded Free Trial Tokens not being used?
I have a PowerBI Pro license and I have used the 'Embed using a service principal guide' here to embed my dashboard into my application. We have the Free trial banner at the top of the embedded report as I would expect, however when I hit the Available Features API using my service principal or my actual Pro account, it's telling me I have used 0% of my free trial embedding tokens. This is depsite refreshing the page showing the dashboard multiple times in a row to try max it out. Has anyone else experienced this at all, or knows why our free trial tokens don't seem to be running out? Any help is appreciated, thanks.Hierarchy row-level security
I have 5 tables. The first table is Access Rights contained below data. Next, the second table is the supply chain contained below data. The third table is the Region contained below data. The fourth table is the Plant contained below data. The first table is the GEO INFO contained below data. I need to Implement a Hierarchical row-level security based on the above data. In the first table, I am a user of [email protected]. For this user Plant is ALL, supply chain is MSC, and Region SAM. I should able to see the data of all Plants data filtered with Region and Supply chain. For example, If Plant is ALL and Supply Chain is ALL and Region is SAM. Then I should be able to see all the Plants and Supply Chain data filtered with Region. If all Plant, Supply Chain, and Region are ALL. Then I should be able to see all the data. It should be dynamic. I need advice on how to implement Row-Level Security (RLS) based on the above requirement. Thank you.Multiple requests for a single Get Data and Refresh Data with Web Data Source
It seem like for a single Web Data Source query Power BI Desktop is issuing a number of requests for the URL and the number of requests for the URL for a single query increases as the records to be returned increases. We have an inhouse REST API server that return a pipe seperated value dataset upon receiving a URL request. For testing purposes we turned on logging in the REST API application so that it will capture the get requests being received. Following are results of the test scenerios with different records size and setting timeout to 30 mins: Web request that return 9 records. a. From invoking the Get Data till showing the Load dialog, 3 requests are received by the REST API server. b. Upon clicking on the LOAD in the dialog 2 additional requests are received by the REST API server. c. With each click of the Refresh 2 additional requests are received by the REST API server. Web request that return 500K records a. From invoking the Get Data till showing the Load dialog, 11 requests are received by the REST API server. b. Upon clicking on the LOAD in the dialog 4 additional requests are received by the REST API server. c. With each click of the Refresh 4 additional equests are received by the REST API server. Web request that return 1M records. a. The Get Data resulted in what seem like never ending loop of get requests to the URL until timeout of 30 mins. If the above observation is correct then for 500K records which take about a mins for the server to response resulted in 20 mins for it to be loaded into Power BI Desktop. It will be quite impossible to load even larger recordset. Have any one experience something similar? Thanks in advance Kin Kheong
