Challice Genest on 14 Jul 2018 01:20:11
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.
- Comments (3)
RE: Power BI Web API Dataset refresh
Try clearing your cache.
RE: Power BI Web API Dataset refresh
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
RE: Power BI Web API Dataset refresh
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