Allow Power BI Web datasets that use APIs and API keys to be able to be refreshed properly. Currently if you run an API to get a dataset then you will run into an issue where tying to update the credentials in "Data source credentials" will not work properly.
4 Comments
- Note: API authentication is called through web, and the API key is often passed as a header value and thus changing the credentials would mean going back to the "Web call edit page" instead of the typical "Edit credential" modal...I'm not sure how this should be resolved but it should be taken into account
- Hello, It seems that the issue is from multiple API call. Into desktop, the credentials are identified only to the token api, when publishing to Power BI Service, Power BI take full connection string in consideration For example : https://apirest.company.com/data/v2/json/getData?&columns={d_time_date,d_device_type,m_vu,CM_94244,CM_106906,m_sales_with_tax}&sort={-m_vu}&space={s:524088}&period={R:{M:'-6'}}&max-results=10000&page-num=1 and https://apirest.company.com/data/v2/json/getData?&columns={d_site,CM_110864}&sort={-CM_110864}&space={s:524088}&period={R:{M:'-6'}}&max-results=30&evo={D}&page-num=1 Are considered same connection into Desktop, different into Service
- Try clearing your cache.
- Status added:Needs Votes
